complete tabs 3 and 4 based on the example showing. please show the formulas in the spreadsheet to show work

ave Of FIN3310_Unit 1_Student_CHO2_Excel_Problems (1) - Protected View Home Insert Draw Page Layout Formulas Data Review View Help EOTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editin > fx A B D E F H K 2.11. Investment Banking: Morrow Inc. is issuing 50,000 bonds and its investment banker has guaranteed a price of $555 per bond. The investment banker sells the entire issue to investors for $15,000,000 a. What is the underwriting spread for this issue? b. What is the percentage underwriting cost? c. How much did Morrow raise? Price per bond guaranteed by investment banker Number of bonds issued Sales proceeds received by investment banker $555 50,000 $15,000,000 a. Underwriting spread ($12,750,000) . Amount of money raised by Morrow $27,750,000 b. Percentage underwriting cost -45.95% EXAMPLE 1 2 3 4 OM v FIN3310_Unit 1_Student_CHO_Excel_Problems (1) Protected View Home Insert Draw Page Layout Formulas Data Review View Help TECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View. Enable Editing fi . A B D E F G K 2.11. Investment Banking: Cranjet Inc. is issuing 10,000 bonds and its investment banker has guaranteed a price of $985 per bond. The investment banker sells the entire issue to investors for $10,150,000. a. What is the underwriting spread for this issue? b. What is the percentage underwriting cost? How much did Cranjet raise? C. 3 9 EXAMPLE 1 2 3 4 RE OH FIN3310_Unit 1_Student_CH02_Excel_Problems (1) - Protected View Home Insert Draw Page Layout Formulas Review View Help TECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Data fx A B D E F H 2.28 Interest Rates: Imagine you borrow $500 from your roommate, agreeing to pay her back $500 plus 7 percent nominal interest in one year. Assume inflation over the life of the contract is expected to be 4.25 percent. What is the total dollar amount you will have to pay her back in a year? What percentage of the interest payment is the result of the real rate of interest? EXAMPLE H2B FIN3310_Unit 1_Student_CH02_Excel_Problems (1) - Protected View ome Insert Draw Page Layout Formulas Data Review View Help CTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X fx D E F 2.29 Interest Rates: Your parents have given you $1,000 a year before your graduation so that you can take a trip when you graduate. You wisely decide to invest the money in a bank CD that pays 6.75 percent interest. You know the trip costs $1,025 right now and that inflation for the year is predicted to be 4 percent. Will you have enough money in a year to purchase the trip? EXAMPLE 12 3 4 v 2 FIN3310_Unit 1 Student CH02_Exce_Problems (1) - Protected View Insert Draw Page Layout Formulas Data Review View Help VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View. Enable Editir - X D E F G STP 2.5 If the nominal rate of interest is 4.25 percent and the expected rate of inflation is 1.75 percent, what is the real rate of interest? EXAMPLE 3 4