Excel File Edit View Insert Format Tools Data Window Help 100% J. Fri Sep 30 8:07:00 PM AutoSave OFF 2 . C ... Lesson 06 Quiz 03 - Student Master Home Insert Draw Page Layout Formulas Data Review View ? Tell me LE Share Comments Arial 12 A A General Conditional Formatting Insert v Format as Table v x Delete v V v Paste BIU BY MV Av $ ~ % 9 500 Sort & Find & Analyze Sensitivity Cell Styles v Format v Filter Select Data F8 X V fx =IF(COUNTBLANK(Quiz_Sheet!F8)=1, "", Quiz_Sheet!F8) A 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 $17,244 with an annual interest rate of 10.00%. The loan will be repaid over 35 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 $740 in one year, $827, in two years, and $952 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 SCORE - This Attempt 32 DON'T FORGET TO UPLOAD TO THE CANVAS ASSIGNMENT LINK. Score & Feedback 33 34 38 A Quiz_Sheet Quiz_Sheet (2) Quiz_Sheet (3) Formulas + Ready + 90% SEP 30 astv 4