PLEASE SOLVE WITH EXCEL FORMULAS

PLEASE PUT EXCEL FORMULAS

Q1.

Before You Begin Please Mote: This question is formula graded. Ensure that you enter your answers in as formulas, when applicable. We require our Excel formulas to be entered as the following: 1. An "=" sign before the formula 2. Reference cells instead of entering values 3. Cell references must be limited to the respective worksheet tab Examples: =E1+F2 OR =SUM(D5:010) Close Matt Enterprises issues 10 percent, five-year bonds with interest paid semiannually. The bonds had the following stated value: Bond stated value: $ 440,000 Calculate the issue price under each of the following three scenarios. Note: The Bond Issue Price should display as a positive number. Scenario Bond Market Formula Inputs Bond Issue Term (Years) Rate RATE NPER PMT FV Price 10%% 596 C. 129%Computing Bond Issue Price On January 2, Randall, Inc., issues $600,000 of 49% bonds that pay interest semiannually and mature in ten years. Compute the bond issue price assuming the following market interest (yield) rate per year compounded semiannually. Consider each case separately. Issue Price a. 49% $ 600.000 b. 6% $ $10.732 C. 2% Check