One spreadsheet assignment involved bond valuation. What is the Excel formula needed to calculate the desired value for spreadsheet cell E27? (Hint: Recall the PV format is: PV(rate, nper, pmt, [fvl, (type]) INPUTS: OUTPUT Price Vield to Guds Mart May Gean CORT 20 14 INPUTS: (alles in the Period thing Yotel Raven 5 cont of Revenue 5 Grupo 5 Depreciation/Amortion Exp $ Other Expense Earnings Before Interes & Tees $ rest Expense $ tans Before To $ TON 's Merino $ Dividende 5 An to Retina Laring $ 2018 Cash And Equivalent 5 1,000,000 Short-Term Investments 5 2.800.000 Receivables $ 133,333 Inventory $ 4.000.000 Current Assets $9,133.33 Gros Plantando $ 66,667 Acred Depreciation $4.000,000 Net Feed Ant 5 10.3667 Total Assets $ 20,000,000 2013 4.000.000 6.000.000 2,000,000 400.000 300,000 1,300.000 200.000 1,100,000 330.000 770.000 7 CH Best Park The Corp Parte Can SS 109 92 A 14 36 1 $ 6 CN FARAH BAS RE 779,000 Total de Acounts Payable $ 400.000 Notas Payable $ 2,000,000 Accrual $ 100,000 Current Latite $ 2,700,000 Long Term Debt $ 3,600,000 Common Stock (10 5.200,000 Metained Earning $ 3.500.000 Total $ 13,700,000 Total Claims $ 20.000.000 over 200 10-20% 20-40% 40-60% 60-70 Over ON AAA AA A 150 D Cash coverage EBITDA Gover Rating OUTDOC Tocal deberano 31.5% Matt 30 over 150 120-15.00 3.0-12.04 LO 30-40 Les than 30 AMA AA A 186 80 3 Coupon Bate Lely Yield 4.9% Estimated Price S913.67 Select one: O a. --PV(D27A27.(827)(10), 1000) O b. = PVD27 A27,827,1000) C-PV(HB.A27,827 10,1000) d. -PV(D27A27.B27-10,1000) One spreadsheet assignment involved bond valuation. What is th walue for spreadsheet cell E27? Hint: Recall the PV format is: PV(rate, nper, pmt, [fv], [type]) IN R INPUTS: (all'$ figures in thousands) Period Ending Total Revenue $ Cost of Revenue $ Gross Profit $ Depreciation/Amortization Exp $ Other Expense $ Earnings Before Interest & Taxes $ Interest Expense S Earnings Before Taxes $ Taxes (30%) $ Net Income $ Dividends $ Addition to Retained Earnings $ 2018E 8,000,000 6,000,000 2,000,000 400,000 300,000 1,300,000 200,000 1,100,000 330,000 770,000 2018E Cash And Equivalents $ 1,000,000 Short-Term Investments $ 2,800,000 Receivables $ 1,333,333 Inventory $ 4,000,000 Current Assets $9,133,333 Gross Plant and Equip $ 6,866,667 Accumulated Depreciation $4,000,000 Net Fixed Assets $ 10,866,667 Total Assets $ 20,000,000 770,000 Tot Acounts Payable $ 400,000 Notes Payable $ 2,000,000 Accruals $ 300,000 Current Liabilities $ 2,700,000 Long Term Debt $ 3,600,000 Common Stock (10 millio$ 5,200,000 Retained Earnings $ 8,500,000 Total Equity $ 13,700,000 Total Claims $ 20,000,000 an OUTPUTS: DDC Total debt ratio 31.5% Maturity 30 EBITDA coverage 8.5 Coupon Rate 4 Likely Rating A Likely Yield 4.5% Estimated Price $918.67 Select one: a. =-PV(D27 A27.(B27)(10), 1000) b. =-PV/D27A27 B27 1000 s the Excel formula needed to calculate the desired INPUTS: Maturity {Years) Company Coupon (% of par) OUTPUTS: Yield to Rating Maturity Price (% of par) Contain Corp Best Packing Travel Corp Custom Packing Premium Cargo 20 24 29 14 26 6 8 + 85 109 92 BB B A BBB BBB 7.5% 7.2% 4.5% 6.3% 5.6% 88 105 Financial Ratio Range Rating Total debt ratio AAA over 20% 10-20% 20-40% 40-60% 60-70% Over 70% A BBB B Cash coverage over 15.0x 12.0-15.0 8.0-12.Ox 4.0-8.OK 3.0-4.ON Less than 3.0 AAA AA BBB BB B Select one: a. =-PV(D27 A27.(B27)(10), 1000) b. =-PV(D27 A27,127,1000) C. =-PV(H8,A27,127*10,1000) O d. =-PV(D27 A27,B27*10, 1000)