Question

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.

Answer 1

As per rules I will answer the first 4 sub parts of this question.

FV	$7,000
Rate	7%
N	7	years
Discounting	PV
1.Annual	($4,359.25)
2. Semiannual	($4,324.47)
3. Quarterly	($4,306.60)
4. Monthly	($4,294.49)
5. Daily	($4,288.59)

The computations are as per the excel below