Excel File Edit View Insert Format Tools Data Window Help 100% Q Fri Sep 30 6:53:58 PM AutoSave OFF ... *Lesson 06 Quiz 03 - Student Master Home Insert Draw Page Layout Formulas Data Review View Tell me LE Share Comments Arial v 11 VA A = ab v Currency Conditional Formatting Insert v E AY Format as Table v x Delete v Paste BIU BY DAY $ ~ % " $08 Sort & Find & Analyze Sensitivity Cell Styles v Format v D Filter Select Data C7 X v fx A B C D E F G H ASSIGNMENT Lesson 06 Quiz 03 Enter Answers Correct Answers 2 points Each Answer (10 Points Total) Below Below Q1) Prepare the first row of a loan amortization schedule based on the following information. The loan amount is for $13,727 with an annual interest rate of 15.00%. The loan will be repaid over 27 years with monthly payments. a) What is the Loan Payment? FIRST NAME LAST NAME Matt DiSabato b) What portion of this payment is Interest? c) What portion of this payment is Principal? INSTRUCTIONS d) What is the Loan balance after first monthly payment? 14 When inputting an answer, round your answer to the nearest 2 decimal places.If you need to use a Q2) What is the most you would be willing to pay for a investment that will calculated number for further calculations, DO NOT round until after all calculations have been pay you $762 in one year, $782, in two years, and $517 in three years, if your required rate of return for this type of investment is 11.00% ? completed. For the final answer, Round to 2 decimal places. 15 16 17 27 28 SCORE - This Attempt 29 FINAL SCORE 0.00 32 DON'T FORGET TO UPLOAD TO THE CANVAS ASSIGNMENT LINK. Score & Feedback 33 34 35 36 37 A Quiz_Sheet Quiz_Sheet (2) Quiz_Sheet (3) Formulas + Ready + 90% 106 30 tv 4