Excel File e Edit View Insert Format Tools Data Window Help 100% (45. Q Fri Sep 30 3:41:06 PM AutoSave OFF ... DiSabato , Matt Lesson 06 Quiz 03 - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me LE Share Comments Arial v 11 VA A = ab v Currency Conditional Formatting v Insert v E AY Format as Table 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 $27,230 with an annual interest rate of 12.00%. The loan will be repaid over 21 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 $886 in one year, $701, in two years, and $924 in three years, if completed. For the final answer, Round to 2 decimal places. 15 your required rate of return for this type of investment is 08.00% ? 16 17 27 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 A X