Calculations in ms excel for the present value

Assignment Help Financial Management

Reference no: EM132031739

Present Values:

Please provide the calculations in MS Excel for the present value of an $7,000 goal in 7 years at 7% discounted on an annual, semi-annual, quarterly, monthly, and daily basis to the nearest penny.

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.

Present Value of an Annuity:

Please provide the calculations in MS Excel for the present value of an annuity amount for an $7,000 payout annually in 7 years at 7% discounted on an annual basis to the nearest penny.

Please provide the calculations in MS Excel for the present value of an annuity due amount for an $7,000 payout annually in 7 years at 7% discounted on an annual basis to the nearest penny.

Future Value of an Annuity:

Please provide the calculations in MS Excel for the future value of an annuity amount for an $7,000 payment annually in 7 years at 7% compounded on an annual basis to the nearest penny.

Please provide the calculations in MS Excel for the future value of an annuity due amount for an $7,000 payment annually in 7 years at 7% compounded on an annual basis to the nearest penny.

Interest Rate Calculation:

Calculate the interest rate to the nearest basis point (0.0001) for a $40,000 investment with an $70,000 financial goal for 7 years. No payments will be made during the 7 years.

Number of Periods Calculation:

Calculate the number of years needed to earn $70,000 with a $50,000 initial investment earning an 7% annual interest rate. Please round to the fourth decimal place. No payments will be made during the 7 years.

APY or EAR:

To the nearest basis point, calculate the yield of 17% on a semi-annual, quarterly, monthly, and daily basis utilizing equation 4.14 on page 167. Show all calculations in MS Excel to the fourth decimal place.

Loan Amortizations:

Please construct an annual loan amortization table for a loan of $40,000 for 4 years at 7%. Please utilize figure 4.11 on page 172. You will have to find the payment first before constructing the amortization table. Make sure to provide the number of periods, the beginning balance, the payment, the interest dollar amount, the principal dollar amount, and the ending balance for each of the five years.

Reference no: EM132031739

Questions Cloud

What was the company cash coverage ratio for the year : The firm paid $3,826 in total interest expense and deducted $2,505 in depreciation expense. What was the company’s cash coverage ratio for the year?

What price would be predicted by duration rule : Find the price of the bond if it's yield to maturity rises to 10%. What price would be predicted by the duration rule?

Difference between net income and cash flow : Explain to Myron the difference between Net Income and Cash Flow.

Calculate the annual coupon rate on the bond : Assuming an annual market interest rate of 14% and that the bond pays interest semiannually, calculate the ANNUAL coupon rate on the bond

Calculations in ms excel for the present value : Please provide the calculations in MS Excel for the present value of an $7,000 goal in 7 years at 7% discounted on an annual,

What is the company cost of equity capital : The Up and Coming Corporation's common stock has a beta of 1.1. what is the company's cost of equity capital?

How much did sally lose by starting : How much did Sally “lose” by starting 15 years later?

Net after-tax return on this bank-qualified municipal bond : The bank is in the 25% tax bracket. What is the net after-tax return on this bank-qualified municipal bond?

Calculate the company wacc : Assume the company’s tax rate is 38 percent. Calculate the company's WACC.

User Account

All Pages