Reference no: EM131093283
Complete the following problem sets in Excel:
1. FutureValue 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.
2. Future Value of an Annuity What is the future value of a $900 annuity payment over five years if interest rates are 8 percent?
3. 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.
4. Present Value of an Annuity What's the present value of a $900 annuity payment over five years if interest rates are 8 percent?
5. 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?
6. Effective Annual Rate A loan is offered with monthly payments and a 10 percent APR. What's the loan's effective annual rate (EAR)?
7. 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? (Calculate monthly payment only)
Heavy construction projects
: As a financial analyst for National Engineering, you are required to estimate the cost of capital the firm should use in evaluating its heavy construction projects. The firm's balance sheet data and other information are listed below. Assume a 35%..
|
Mean-variance preferences and utility function
: FundY:E[rY]=34%,σY =40% You have mean-variance preferences and utility function:
|
Implement c program for evaluating the polynomial
: Implement C program for evaluating the polynomial f(x)= a 4 x 4 +a 3 x 3 +a 2 x 2+ a 1 x 1 +a 0 for a given value of x and its coefficient using Horner's method.
|
Determine the required rate of return on kci stock
: a. Using the Capital Asset Pricing Model, determine the required rate of return on KCIstock. b. Comment on the riskiness of KCI compared to the market.
|
Compute the future value
: FutureValue 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.
|
Give an example of activity-based costing methods
: Give an example of activity-based costing methods by creating a fictitious company. Include a cost analysis. Discuss the 2-3 advantages of the ABC method.
|
Find the moment of inertia
: MOMENT OF INERTIA Q1.Find the moment of inertia of given figure about centroidal axes. IXX=12848.98mm4,IYY=13343.72mm4
|
What is the intended purpose of the federal gift tax
: What is the intended purpose of the Federal gift tax? Hilda, a U.S. citizen, has established her residence in Costa Rica in order to avoid the U.S. estate tax. Comment on the value of Hilda's planning.
|
Information concerning a capital budgeting project
: The expected life of the project and the equipment is 3 years and the equipment has zero salvage value. The company uses straight-line depreciation on all equipment and the depreciation expense on the equipment would be $150,000 per year.
|