Question: How do you calculate this in excel ?? 5 3 ,000 Consider the cash flows presented in the table below. What is the present value

How do you calculate this in excel ??

5 3 ,000 Consider the cash flows presented in the table below. What is the present value if the appropriate intere rate is 7 percent compounded annually? Year Cash Flow 19,000 2 12,000 5,000 17,000 8,000 What is the present value of $14,000 per year for 15 years if the interest rate is 6%? You are going to borrow $650,000 to buy a house. What will your monthly payment be if the annual interest rate is 3.8 percent and you borrow the money for 30 years? You borrow $12,000 to be repaid in 4 equal payments at the end of each of the next 4 years. The bank charges 4 percent compounded annually. Prepare the loan amortization schedule. Hline Extended DANT

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. Has your company issued any long-term bonds or notes in the most recent year? If so, read the note related to long-term debt, identify one of the bonds or notes and list any special features...

Review the income statement. What was recorded as discontinued operations for the most recent fiscal year? What was managements explanation for this amount? What is the functional currency of the...

Beyer Company is considering the purchase of an asset for $190,000. It is expected to produce the following net cash flows. The cash flows occur evenly within each year. Assume that Beyer requires a...

5. Consider the cash flows presented in the table below. What is the value of the cash flows in year 5 if the interest rate is 4 percent compounded annually? Year Cash Flow 1 8,000 2 4,000 3 9,000 4...

Beyer Company is considering the purchase of an asset for $230,000. It is expected to produce the following net cash flows. The cash flows occur evenly within each year. Assume that Beyer requires a...

8. Replacement analysis Purple Turtle Group is a company that produces IGadgets, among several other products. Suppose that Purple Turtle Group considers replacing its old machine used to make...

Ch 13: Assignment- Capital Budgeting: Estimating Cash Green Moose Industries is a company that produces iWidgets, among several other products. Suppose that Green Moose Industries considers replacing...

Ranger Corporation has decided to invest in renewable energy sources to meet part of its energy needs for production. It is considering solar power versus wind power. After considering cost savings...

8. Replacement analysis Green Moose Industries is a company that produces iBooks, among several other products. Suppose that Green Moose Industries considers replacing its old machine used to make...

Cullumber Company is considering purchasing new equipment for $333,700. It is expected that the equipment will produce net annual cash flows of $47,000 over its 10-year useful life. Annual...

The weight of an object near a supermassive object is given by g = 325 p2 -N A space probe is currently 1700 meters from the object. How much work is required to move it to a distance of 3400 meters...

The author surveyed the students in one of his algebra classes, asking them their ages. Here are their responses: a. Construct a dotplot. b. What proportion of the observations are between 20 and 22...

Equipment costs $ 4 7 , 5 0 0 and is depreciated straight line to zero over 4 years. The tax rate is 2 1 % . The project's discount rate is 9 . 7 5 % . What is the after tax salvage value if the...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...