I need a expert
Budget: $10 – $30 USD
Create a blank spreadsheet and follow the same steps as in the first part of the video. Below are extra notes to the video.
Cells A1, A2, A3, A4, and A6 are labels.
Cells B2, B3, and B4 are values that you enter based on data from the lecture or video.
The remaining cells in column B are based on calculation you enter. Again, refer to the lecture or video.
Once you finish the example as shown in class, create a new sheet in the same workbook and create your own loan payment calculations:
Under "Loan Amount" type in the amount of a car that you would like to buy in the future.
Research the price of your dream car on the web.
Type in different values for "Interest Rate" and "Years."
Use the internet to research loan rates and terms (years).
For your assignment you should have used the =pmt() function twice: the first time using the example data from lecture or video, and the second time using your own data.
Cells A1, A2, A3, A4, and A6 are labels.
Cells B2, B3, and B4 are values that you enter based on data from the lecture or video.
The remaining cells in column B are based on calculation you enter. Again, refer to the lecture or video.
Once you finish the example as shown in class, create a new sheet in the same workbook and create your own loan payment calculations:
Under "Loan Amount" type in the amount of a car that you would like to buy in the future.
Research the price of your dream car on the web.
Type in different values for "Interest Rate" and "Years."
Use the internet to research loan rates and terms (years).
For your assignment you should have used the =pmt() function twice: the first time using the example data from lecture or video, and the second time using your own data.