Reference no: EM133153872
On a new sheet of the same file, create a worksheet that contains data and a calculation determining monthly payments for a proposed purchase. Include the following:
-Identify your dream vehicle (plane, automobile, boat, etc.) and estimate its cost and the annual interest rate if you financed its purchase.
-Enter text labels in Column A for Loan Amount, Interest Rate (APR), Term in Years, Payment, etc., onto the spreadsheet.
-Enter the numbers for each item in Column B, except the monthly payment of course. We'll use a function to determine this.
-Apply appropriate number formatting (currency, percentage) where appropriate.
-To calculate the monthly payments, use the PMT function with cell references. Ensure you are converting the term and interest per the tutorial. Do so within the function.