I need my exam done as well, You will need to login the school website, using my credentials to take the exam
Instructions Click on the "Bond 1" tab and enter your name in Cell C1. If Cell C1 is left blank, you will not be able to see your score. Each yellow cell requires a formula. The formula must only contain cell addresses. Each correct formula will begin with =, +, or -. The basic mathematical operators are +, -, * and / Addition: To add the values in cells A1 and B4, the formula is =A1+B4 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is =A1-B4 Multiplication: To multiply the values in cells A1 and B4, the formula is =A1*B4 Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4 Using the PV function: The PV function has the following syntax: =-PV(Rate,Nper,Pmt,Fv,Type) Note: To return the issue price as a positive value, you must include a negative sign, either before the PV or as a negative payment amount. Bond 1 Name:Your score this tab:ERROR:#VALUE! FaceMarketTermContractpays per year Enter Name in Cell C1 to Begin CompanyCompoundedMarketTermContract0 Face000%00%000000 quarterlya4000000.0630.052 Semiannualb4100000.0740.062 Number of pays0c4200000.0850.072 Par Value$0Issue Priced4300000.0930.082 Term (years)0e4400000.140.092 Annual market %0%f4500000.1150.12 Annual contract %0%g4600000.1230.112 Payments per year0h4700000.0640.052 i4800000.0750.062 Isblank Check?IsFormula Check?Correct?j4900000.0830.072 What is the amount of each quarterly interest payment?ERROR:#VALUE!010000k5000000.0940.082 005000l5100000.150.092 ERROR:#VALUE!025000m5200000.1130.12 0n5300000.1240.112 0o5400000.0650.052 0p5500000.0730.062 Quarterly Interest PeriodCash Interest PaidBond Interest ExpenseDiscount AmortizationUnamortized DiscountCarrying Valueq5600000.0840.072 0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!20000ERROR:#VALUE!ERROR:#VALUE!r5700000.0950.082 0000000000000000001000ERROR:#VALUE!ERROR:#VALUE!s5800000.130.092 0000000000000000002000ERROR:#VALUE!ERROR:#VALUE!t5900000.1140.12 0000000000000000003000ERROR:#VALUE!ERROR:#VALUE!u6000000.1250.112 0000000000000000004000ERROR:#VALUE!ERROR:#VALUE!v6100000.0630.052 0000000000000000005000ERROR:#VALUE!ERROR:#VALUE!w6200000.0740.062 0000000000000000006000ERROR:#VALUE!ERROR:#VALUE!x6300000.0850.072 0000000000000000007000ERROR:#VALUE!ERROR:#VALUE!y6400000.0930.082 0000000000000000008000ERROR:#VALUE!ERROR:#VALUE!Z6500000.140.092 0000000000000000009000ERROR:#VALUE!ERROR:#VALUE! 00000000000000000010000ERROR:#VALUE!ERROR:#VALUE! Totals$0.00$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!4200ERROR:#VALUE! Bond 2 Name: Your score this tab: Average score both tabs:ERROR:#VALUE!FaceMarketTermContractpays per year The Company issues 0%, 0-year bonds with a par value of $0 and quarterly interest payments. On the issue date, the annual market rate for these bonds is 0%. Enter a valid Excel formula or function in each of the yellow cells below. Formulas must refer to cells addresses. Entering a value will be marked as incorrect. CompanyCompoundedMarketTermContract0 Face000%00%000000 quarterlya3500000.0530.062 Semiannualb3600000.0640.072 Number of pays0c3700000.0750.082 Par Value$0Issue Priced3800000.0830.092 Term (years)0e3900000.0940.12 Annual market %0%f4000000.150.112 Annual contract %0%g4100000.1130.122 Payments per year0h4200000.0540.062 i4300000.0650.072 Isblank Check?IsFormula Check?Correct?j4400000.0730.082 What is the amount of each quarterly interest payment?ERROR:#VALUE!010000k4500000.0840.092 005000l4600000.0950.12 ERROR:#VALUE!025000m4700000.130.112 0n4800000.1140.122 0o4900000.0550.062 0p5000000.0630.072 Quarterly Interest PeriodCash Interest PaidBond Interest ExpensePremium AmortizationUnamortized PremiumCarrying Valueq5100000.0740.082 0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!20000ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!r5200000.0850.092 0000000000000000001000ERROR:#VALUE!ERROR:#VALUE!s5300000.0930.12 0000000000000000002000ERROR:#VALUE!ERROR:#VALUE!t5400000.140.112 0000000000000000003000ERROR:#VALUE!ERROR:#VALUE!u5500000.1150.122 0000000000000000004000ERROR:#VALUE!ERROR:#VALUE!v5600000.0530.062 0000000000000000005000ERROR:#VALUE!ERROR:#VALUE!w5700000.0640.072 0000000000000000006000ERROR:#VALUE!ERROR:#VALUE!x5800000.0750.082 0000000000000000007000ERROR:#VALUE!ERROR:#VALUE!y5900000.0830.092 0000000000000000008000ERROR:#VALUE!ERROR:#VALUE!Z6000000.0940.12 0000000000000000009000ERROR:#VALUE!ERROR:#VALUE! 00000000000000000010000ERROR:#VALUE!ERROR:#VALUE! Totals$0.00$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!4200ERROR:#VALUE!11000ERROR:#VALUE!ERROR:#VALUE! 12000ERROR:#VALUE!ERROR:#VALUE! 13000ERROR:#VALUE!ERROR:#VALUE! 14000ERROR:#VALUE!ERROR:#VALUE! 150 Sheet1 CellYou entered:Feedback F8No entryThis is not a valid formula.