PLEASE PLEASE PLEASE HELP ME WITH THIS INTERMEDIATE EXCEL ASSIGNMENT

Excel Assignment Please note, Excel spreadsheets that are not able to automatically calculate bond prices and cash flows for any change in interest rates, maturity, or cash in-flows will not satisfy the requirements for this assignment! Estimates change in business and Excel files should be set up or linked to automatically adjust to changes. Bond Pricing: You are to determine the price of each of the bonds at issuance. Prepare a table showing the amount of interest, principle, and total price of each of the bonds below. Again, your spreadsheet should update for any change in face amount, interest rates, maturity, or payment frequency (I will input data into your spreadsheet to test these items.). Below are the bonds: Issuance Date Face Amount of Bond Maturity Date Stated Rate Market Rate Payment Frequency 9/30/2016 $1,000,000 9/30/2036 8% 10% Semiannual 11/15/2016 $750,000 11/15/2021 12% 6% Annual 3/15/2016 $1,250,000 6/15/2026 13% 15% Quarterly In addition, assume that the company has issued the above bonds. Prepare the journal entries at the date of issuance and the first interest payment date (Hint: The interest payment date will be based upon the payment frequency.). Journal entries should be prepared for each of the bonds. Remember that the numbers on the journal should be linked so that they update too. Cash Flow Analysis: Using Excel Functions, determine the discounted cash flow of the following purchase of a new plant facility. Given a required rate of return of 8 percent and that the plant costs $2M, determine whether the company should invest in the plant. Make sure to again link all the inputs in excel in case projected costs or inflows change. Year Initial Cost & Maintenance Projected Revenue Depreciation Total Annual Cash Flow Cumulative Cash Flow 0 ($2,000,000) ($2,000,000) ($2,000,000) 1 ($6,500) 2 ($6,500) 3 ($10,500) 4 ($10,500) 5 ($12,000) 200,000 -25,000 $168,500 ($1,831,500 ) 500,000 -51,200 $442,300 ($1,389,200 ) 600,000 -51,200 $538,300 ($850,900 ) 750,000 -51,200 $688,300 ($162,600 ) 900,000 -51,200 $836,800 $674,200