Calculations in ms excel for future value

Assignment Help Financial Management
Reference no: EM132032304

1. Future Values: Please provide the calculations in MS Excel for a future value of an $7,000 investment today in 7 years at 7% compounded on an annual, semi-annual, quarterly, monthly, and daily basis to the nearest penny.

2. What dollar amount, when compounded at 5% for ten years, will grow to a value of $40,722.37? Round to the nearest dollar: enter your answer without using commas or dollar signs.

Reference no: EM132032304

Questions Cloud

Describe how khali rafatis life an example of heterogeneity : Describe how Khali Rafati's life an example of heterogeneity or state dependence ?
Future value of annuity : calculations in MS Excel for future value of annuity due amount for $7,000 payment annually in 7 years at 7% compounded on an annual basis to nearest penny.
Review problem on payment using given information : A perpetuity-immediate pays $X per year. Brian receives the first n payments, Colleen receives the next n payments, and Jeff receives the remaining payments.
Calculate the amount of quarterly repayment : Calculate the amount of the quarterly repayment. Calculate the loan outstanding right after the 10th payment.
Calculations in ms excel for future value : Please provide the calculations in MS Excel for a future value of an $7,000 investment today in 7 years at 7% compounded on an annual,
Determine the expected retirement withdrawals : A person was able to invest $5,000 a year at the end of years 1 through 12 in an account which paid 7% interest compounded annually.
Distinguishes scenario analysis from sensitivity analysis : Which of the following distinguishes scenario analysis from sensitivity analysis? Which of the following statements is true regarding internal rate of return.
Find an expression of the present value : A perpetuity starting January 1, 2017 pays 2 every January 1 in odd years and 3 every January 1 in even years. Find an expression of the present value.
What is the most the person should be willing to pay : A person plans to purchase a rental house which promises to provide $9000 in rental income at the end of each year, but require $2500 in expenditures.

Reviews

Write a Review

Financial Management Questions & Answers

  Calculate the price-macauley-modified duration of five year

Calculate the Price, Macauley and modified duration of a five year 5.5% annual coupon bond (Par Amount $100) selling for a YTM of 5.4%.

  Statement that equity is call option on the firm assets

Explain the rationale behind the statement that equity is a call option on the firm’s assets. When would a shareholder allow the call to expire?

  What will be our average number of boxes on hand

Our home construction company buys nails in 15-pound boxes. We use an average of 1507 boxes a year. The vendor that makes the nails can produce 45 boxes per day while our usage is 17 boxes per day. It costs $2.70 to place the typical order. Annual ca..

  Compute the cash flow for johnson siding

Johnson Siding has a gross profit of $1,200,000 and $400,000 in depreciation expense. Selling and administrative expense is $250,000. Given that the tax rate is 40 percent, compute the cash flow for Johnson Siding

  What message might you provide to your ceo

Your CEO comes to you armed with the latest earnings results of a major competitor. What message might you provide to your CEO and what type of bias may he be reflecting?

  The present value of expected free cash flows

what is a formulat for the present value of expected free cash flows when discounted at the WACC?

  Prepare new contribution format income statement

Miller Company’s most recent contribution format income statement is shown below: Total Per Unit Sales (33,000 units) $198,000 $6.00 Variable expenses 99,000 3.00 Contribution margin 99,000 $3.00 Fixed expenses 44,000 Net operating income $ 55,000. P..

  Cost-reduction and profit-sharing program

Discuss the major differences between cost-reduction and profit-sharing program, including the philosophic issues underlying each type of program.

  Compounding period is the same as the payment period

Find the payment that should be used for the annuity due whose future value is given. Assume that the compounding period is the same as the payment period. $79,000; monthly payments for 11 years; interest rate 6.3%.

  Calculate the percentage changes in eps when the economy

calculate the percentage changes in EPS when the economy expands or enters a recession.

  Preparing project proposal

you are preparing a project proposal (also called a statement of work) that will be given to prospective shareholders, clients or donors.

  Evaluate the project on today dollars basis

Evaluate the project on a “today’s dollars” basis. That is, neglect all price and cost escalation. Use ROR, NPV, and PVR as your evaluation methods.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd