Excel File Edit View Insert Format Tools Data Window Help \\ 100% @3- AutoSave .orr Q P) '9 v G in Lesson 06 Quiz 01 - Student Master Home Insert Draw Page Layout Formulas Data Review View 9 Tell me 6 Share Cl Comments ' 2g Arial v 11 v AA AV Currency V a Conditional Formatting v . . Insert v Z v 7 i ' r p v [E v 1; Format as Table v I: . Delete v V ' Paste 0 60 00 ,_. Sort & Find 8t Analyze Sensitivity 6 B I u v Oi v A v $ V A) 9 ,oo >.o A Ce\" Styles v Format v 0 v Filter Select Date c7 3 fx v A B C D E F G H J I 1 z : ASSIGNMENT Lesson 06 Quiz 01 5 Enter Answers Correct Answers 6 Zpoints Each (10 Points Total) Below Below Q1) Suppose you signed a contract fora special assignment over the next 11 years. You will be paid $21,894 at the end of each year. If your required 7 rate of return is 08.00%, what is this contract worth in today? I FIRST NAME LAST NAME 8 Matt DiSabato 02) You need a loan to purchase new equipment. The loan will be paid off over 14 years with payments made at the end of every quarter. lithe stated annual rate is 20.00% and quarterly payments are 8143, what is the loan 9 amount? 10 03) You would like to purchase a carter $6,116. It the car loan is 06.00% 11 nanced over 3 years. what will the monthly payments be for this car? INSTRUCTIONS 12 04)What is the most that you would pay tor an investment that promises to pay $19,967 a year forever with the first payment starting one year from 7 . , - . o 13 now. Assume that your required we 0' return lorthls investment '5 30'00 A" When inputting an answer. round your answer to the nearest 2 decimal placest you need to use a 14 calculated number for further calculations, DO NOT round until after all calculations have been 05M loan has a stated annual rate ot15.00%. ll loan payments are made completed For the nal answer Round to 2 decimal places monthly and interest is compounded monthly, what is the effect'we annual ' ' ' 15 rate of interest? 15 L 27 28 SCORE - Thls Attempt A 32 DON'T FORGET TO UPLOAD TO THE CANVAS ASSIGNMENT LINK. Score & Feedback 33 a Quizisheet H Qui Sheet (2) a Quizisheet (3) a Formulas + Ready E El PTl + 90% I a SEP Q A m . g 5