Calculate how much deposit

Assignment Help Financial Management

Reference no: EM131077882

Interest Table: Create a spreadsheet to calculate how much a deposit of $1,000 would be worth if left in a bank for ten years at 6.5 percent annual interest. Show princi- pal and interest for each year as follows: Annual Interest Rate: .065 YEAR PRINCIPAL INTEREST 1 $1,000.00 (a) 2 (b) At the bottom of the PRINCIPAL column, create a line sparkline to show its growth. NOTE: Note that the interest in cell (a) is the principal to its left times the absolute reference to the cell that contains .065. The new principal in cell (b) is the old principal plus the interest in the row above it. Can i get assistance o n how to do the calculations on the excel spread sheet for. i am stuck

Reference no: EM131077882

Questions Cloud

Convergence property the open interest marking to market : At maturity of a futures contract, the spot price and futures price must be approximately the same because of __________. the triple witching hour the convergence property the open interest marking to market

Local convention center to help pay for maintenance. : Berklin County has a deal with the local convention center to help pay for maintenance. The county will pay $4817 each month and increase its payment by 0.5% each subsequent month. The county has committed to paying this maintenance for 10 years. How..

Result in initial aftertax cash savings : Nally, Inc., is considering a project that will result in initial aftertax cash savings of $6.8 million at the end of the first year, and these savings will grow at a rate of 3 percent per year indefinitely. What is the maximum cost Nally would be wi..

What is the market value of the companys debt : Bennington Industrial Machines issued 139,000 zero coupon bonds four years ago. The bonds originally had 30 years to maturity with a yield to maturity of 6.9 percent. What is the price of the bonds? What is the market value of the company's debt?

Calculate how much deposit : Interest Table: Create a spreadsheet to calculate how much a deposit of $1,000 would be worth if left in a bank for ten years at 6.5 percent annual interest. Show princi- pal and interest for each year as follows:

Determine the amount of dollars it will pay for the payables : Wilson Ltd. Corporation will need to purchase 200,000 British pounds in 90 days. A call option exists on British pounds with an exercise price of $1.68, a 90 day expiration date, and a premium of $.04. Determine the amount of dollars it will pay for ..

The effective corporate tax rate : A project requires an initial investment of $100,000 and is expected to produce a cash inflow before tax of $27,000 per year for five years. Calculate project NPV for each company. What is the IRR of the after-tax cash flows for each company? What d..

What is npv that makes you indifferent between two options : Suppose that you are approached with an offer to purchase an investment that will provide cash flows of $1,300 per year for 15 years. The cost of purchasing this investment is $9,200. You have an alternative investment opportunity, of equal risk, tha..

Which is the combined risk of the firm equity and debt : The firm's weighted average cost of capital, denoted rwacc, is the cost of capital that reflects the risk of the overall business, which is the combined risk of the firm's equity and debt. When using the discounted free cash flow model we should use ..

User Account

All Pages