Question: Could you also show the excel functions used to solve. (10 points) Solve the following: a. Find the present value of $11,200 nine years from

Could you also show the excel functions used to solve.

Solve the following: a. Find the present value of $11,200 nine years

(10 points) Solve the following: a. Find the present value of $11,200 nine years from now. The interest rate is 8%. b. Find the present value of $15,500 per year for 10 years with the first payment at the end of the first year at 8% interest. c. How long will it take to repay a 8% loan of $107,200 if $13,000 is paid at the end of each year. d. What would be the annual payment on a $475,600, 20 year loan at 12% interest. e. Find the value of a $1,000 bond paying $75 every six months and maturing 10 years from now if the current rate of interest is 13% compounded semiannually. 11200 -6 D E F C B Problem 4 c. b. d a. e PV FV INT Rate PMT NPER 8% 11200 1 2 3 4 5 6 7 8 9 20 21 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

1. A U.S. bank issues a 1-year, $1 million U.S. CD at 5 percent annual interest to finance a C $1.274 million investment in 2-year fixed-rate Canadian bonds selling at par and paying 7 percent...

Important note: Solve the following THREE questions by using the excel sheet on your computer, then copy the tables which you created and paste them on a word document. Print your word document and...

Write a 3-4 pages disclosure for each of the scenario in the attached file.Thank you There are NO FINANCIAL STATEMENTS TO prepare here. 1. Write a disclosure for each scenario. Keep it simple, but...

please show all formulas and calculations, thanks! For each of the following, compute the future value: For each of the following, compute the present value: Solve for the unknown interest rate in...

Hi! I need help on finishing what I could not figure out. I got the basic analysis part and tornado diagram finished. I need help on the breakeven and the CP part. If you could look over the WACC tab...

MaDonna's has just completed an initial public offering. The firms sold 6 million shares at an offer price of $16 per share. The underwriting spread was $.50 per share. The price of the stock closed...

show formulas fixed figures referred to the table to answer the spreadsheet. interest rate is shown on this spreadsheet You don't need to build a table. Many functions are provided with Excel to...

let me know I will increase the price if you really solve the problem. Introduction: You have recently been hired as a Financial Analyst in the Finance Department of Zeta Auto Corporation which is...

let me know if can solve and write a 1 page summary Zeta Spenza Project Given MACRS Schedule year 1 year 2 year 3 year 4 Monza's sales in 2015 10,000 Monza's price $65,000 Monza Cost structure per...

I need help writing therecommendation to the CFO (not the executive summary). I have already completed the attached excel workbook. Introduction: You have recently been hired as a Financial Analyst...

Sam, a single taxpayer, acquired stock in a corporation that qualified as a small business corporation under 1244 at a cost of $100,000 three years ago. He sells the stock for $10,000 in the current...

Is an accrual method taxpayer permitted to deduct estimated expenses? What about prepaid expenses? Explain.

Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for a Time Period that Differs from the Data Period Refer to the information for Hungry Hannahs above. Assume that this...

3. See the yellow circle on the robots foot. How can the Jacobian be used to describe the velocity of the foot in the world reference frame? Assume that you have the joint velocities (). Transcribed...