Excel File e Edit View Insert Format Tools Data Window Help 100% . Q Sun Oct 2 2:57:48 PM AutoSave OFF ... Lesson 06 Quiz 02 - Student Master (1) Home Insert Draw Page Layout Formulas Data Review View Tell me LE Share Comments Arial v 12 V AA = ab General Conditional Formatting Insert v Format as Table v x Delete v Paste BIU BY DV Av $ ~ % " $08 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 J OUT A W N + ASSIGNMENT Lesson 06 Quiz 02 Enter Answers Correct Answers 2 points Each Question (10 Points Total) Below Below Q1) You invest $4,938 at the beginning of every year and your friend invests $4,938 at the end of every year. If you both eam an annual rate of return of 03.00%. a) how much will you have in your account after 6 years? FIRST NAME LAST NAME Matt DiSabato 10 00 b) How much will your friend have in his account? Q2) You currently have $1,900 in a retirement savings account that eams an annual return of 06.00%. You want to retire in 46 years with $1,000,000. How much more do you need to save at the end of every year to reach your INSTRUCTIONS 11 retirement goal? 12 Q3) You currently owe $4,059 to your credit card that charges an annual interest rate of 16.00%. You make $154 of new charges every month and make a payment of $217 every month. What will your credit card balance be 13 in three months? 14 When inputting an answer, round your answer to the nearest 2 decimal places.If you need to use a Q4) You would like to retire in 22 years. The expected rate of inflation is calculated number for further calculations, DO NOT round until after all calculations have been 02.00% per year. You currently have a standard of living that requires completed. For the final answer, Round to 2 decimal places. $8,336 of monthly expenses. Assuming you want to maintain the same standard of living in retirement, what are your monthly expenses expected 15 to be the first year of retirement? 16 Q5) You purchases a house for $240,560. You made a down payment of $20,000 and the remainder of the purchase price was financed with a mortgage loan. The mortgage loan is a 30 year mortgage with an annual interest rate of 07.00%. Mortgage payments are made monthly. What is the 17 monthly amount of your mortgage payment? 27 Quiz_Sheet Quiz_Sheet (2) Quiz_Sheet (3) Formulas + Ready + 90% OCT atv 4 -120 2 O X