### Compute the future value and the present value

Assignment Help Financial Management
##### Reference no: EM131145848

Complete the following problem sets in Microsoft Excel:

• Future Value: Compute the future value in year 9 of a \$2,000 deposit in year 1 and another \$1,500 deposit at the end of year 3 using a 10 percent interest rate.

• Future Value of an Annuity: What is the future value of a \$900 annuity payment over five years if interest rates are 8 percent?

• Present Value: Compute the present value of a \$2,000 deposit in year 1 and another \$1,500 deposit at the end of year 3 if interest rates are 10 percent.

• Present Value of an Annuity: What's the present value of a \$900 annuity payment over five years if interest rates are 8 percent?

• Present Value of an Annuity: Due If the present value of an ordinary, 6-year annuity is \$8,500 and interest rates are 9.5 percent, what's the present value of the same annuity due?

• Effective Annual Rate: A loan is offered with monthly payments and a 10 percent APR. What's the loan's effective annual rate (EAR)?

Calculate monthly payment only:

• Loan Payments: You wish to buy a \$25,000 car. The dealer offers you a 4-year loan with a 9 percent APR. What are the monthly payments? How would the payment differ if you paid interest only? What would the consequences of such a decision be?

#### Use the irr approach to find the maximum shutdown costs

Use the IRR approach to find the maximum shutdown costs you could incur and still meet your cost of capital of 15% on this project.- Draw timeline and include all workings i

#### Report on a budget information problem

report on a budget information problem.-  Problem identification:- Analysis (investigation):- Conclusion to the analysis (results of the investigation):The solution, listed as

#### How firms raise funds through the use of debt

Identify how firms raise funds through the use of debt, equity, and retained earnings - steadily making payments and has an excellent personal and business credit history.

#### Formulate the integer programming model for given problem

The Texas Consolidated Electronics Company is contemplating a research and development program encompassing eight research projects. - Formulate the integer programming model

#### Calculate the press brakes net present value

Jefferson Products, Inc., is considering purchasing a new automatic press brake, which costs \$300,000 including installation and shipping. - Calculate the press brake's net p

#### Discuss a bank financial management related study

You are required to write a report to comprehensively and critically discuss a bank financial management related study. In choosing a topic, you could consider the Risks of

#### What is the annual straight-line depreciation for the assets

A firm is considering purchasing an asset that will have a useful life of 10 years and cost \$5 million; it will have installation costs of \$500,000 and a salvage or residual

#### Examine behavior within firms in relation to financial mgmt

examine ethical behavior within firms in relation to financial management. Provide two examples of companies that have been guilty of ethics-based malfeasance related to fin