Please provide the calculations in MS Excel for the future value of an annuity due amount for an $8,000 payment annually in 8 years at 8% compounded on an annual basis to the nearest penny.
Calculate the interest rate to the nearest basis point (0.0001) for a $40,000 investment with an $80,000 financial goal for 8 years. No payments will be made during the 8 years.
Calculate the number of years needed to earn $80,000 with a $60,000 initial investment earning an 8% annual interest rate. Please round to the fourth decimal place. No payments will be made during the 8 years.
To the nearest basis point, calculate the yield of 18% 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.
Please construct an annual loan amortization table for a loan of $40,000 for 5 years at 6%. 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.