I need help on this 5 part excel Time Value problem, using either excel functions or formulas, preferably excel functions. Thank you!

1 The bank at which you work makes a discount loan to a customer in the principal amount of 575,000. The term of the loan is 10 years and the interest rate is 39%. Even though all interest and principal is repaid at maturity, the bank must report the amount of interest earned each year to the IRS for tax purposes. The tax rate is 24%. Create a schedule that shows the initial proceeds of the loan, the accretion of interest each year, and finally the amount to be repaid as the final result of the scedule. This will look similar to an amortization schedule. Then, calculate the annual taxes due. 2. See section 4 8 in the text. You win the lottery and have a choice of receiving a lump sum payment of $7,500,000 today, or $600,000 at the end of each year for 20 years, Calculate the 'indifference interest rate'- the rate you could earn on your lump-sum payout that would leave you indifferent between receiving the lump sum of the annuity Then, calculate the annual return you would get if you took the lump sum and eamed 8% on that balance 75,000 10 240% Lump sum payment option: Annual payment option Annuity payments (if chosen) Indifference rate: 7,500,000 600.000 20 Year Beginning Balance Annual Interest Ending Balance Annual Taxes 3 1 2 3 4 5 6 7 8 9 10 Referring to problem 2. what rate of return, if it could be eamed consistently over time on the lump sum option, would provide you with a perpetuity of $600,000 - rather than just a 20-year annuity? If market interest rates for 20-year loans are 3.25%, which option should you choose? What will be the total profit for the bank over the term of the loan? 5 Read the Handout "impact of Compounding periods in the same folder as this challenger problem. The stock XYZ pays a quarterly dividend of S1 25 per share. Assume the dividend will continue at the same amount in perpetuity. If the APR discount rate is 6.4%, what is the value of a share of XYZ today? 1.25 6.40% student name main Type here to search o