AutoSave On EXCEL project Student (1) (version 1) Saved File Home Insert Page Layout Formulas Data Review View Help Calibri 11 v ' ' Paste BIU v v v Search (Alt+Q) Rukeya Tartt Insert General Delete $ % 500-00 Conditional Format as Cell Formatting Table Styles Format Alignment Number Styles Cells RT Comments Share x Sort & Find & Filter Select Analyze Data Editing Analysis J K L M N P R S T U V Undo Clipboard Font > 110 : X fx =(E5*2) A B C D E F H 1 2 3 4 Instructions: Complete all cells shaded green. All answers must be determined using EXCEL formulae. Question 3 On January 1, 2021 a Company acquired machinery and issued a noninterest bearing note: Face amount 5 Payable in 6 Market interest rate $825,000 10 years 8% for similar borrowings 7 8 Answer the following questions: 9 10 1) What are the total number of interest periods? 11 12 2) What is the market interest rate per semi-annual interest period? 33,000 13 14 3) What is the face amount payable in 10 years? 20 2 points 2 points 2 points 15 16 4) Using the VLOOKUP function, identify the present value factor for the 17 calculation of the present value of the face amount from the sheet 'PV of $1'. 2 points 18 19 20 5) Calculate the present value of the face amount at January 1, 2021, using the PV factor from (4) above. 2 points 21 22 Note: points will only be assigned where the answer is determine using EXCEL formulae or cell references. 23 Q1 PMT, NPER, IRR Ready Accessibility: Good to go Q2 PV Bonds Q3 Vlookup PV of $1 Factor table Q4 SLN Q5 DDB 67F Cloudy B + 90% 7:45 PM 4/17/2022