ValueAmountPaidAmountOwedEquity(dollarvalue)Equity(percent)????? Since it is important to not round until the final step of the calculations, the spreadsheet applet above and its bull-in formulas will be very helpful answering the questions below. H.E. Pennypacker, a wealthy American industrialist, is looking to purchase a silver mine in the mountains of Peru. In need of a loan, Pennypacker finances the entire value of the mine and borrows $276,078,500 from Varnsen Savings and Loan. The terms of the loan stipulate that Pennypacker will pay an annual interest rate of 3.26%, compounded quarterly, for a term of 20 years. (a) First, determine the "future value" of the loan, from the perspective of Vacnsen Savings and Loan. To the direclors of Varnsen S\&L, when an amount of $276,078,500 is compounded quarterly for 20 years, what is the future value of the money? To use the spreadsheet, enter the interest per period in cell B4. You should be entering a fraction here, NOT a rounded number. Remember to arrow cut of the cell instead of hitting enter. Then enter the total number of compounding periods for the duration of the loan in B5. The future value of the loan will be calculated in cell B6. We will round this value to the nearest cent and use the rounded value for future calculatons: From the perspective of Vamsen S\&L, the Future Value of the loan will be \$ (round to the nearest cent) (b) From the list below, identify the formula used by the spreadsheet to compute the answer to part (a) A. F=(nr)P((1+nr)nt1) B. F=P(1+rt) c. F=Pen D. rE=(1+nr)n1 E. F=P(1+nr)nt F. None of these (c) Fill in the blanks below with the values that should be used for each variabie in the formula chosen in part (b). If a leterer is listed that is not part of the formula, enter "NONE" in the blark. P=n=t= (d) Now, when preparing the loan paperwork and agreements, Vamsen Savings and Loan needs to determine what Pennypacker's payments will be in order repay the loan. From the perspective of Varnsen, they can think of the payments as an ordinary annuity, with a goal of reaching the future value found in part (a). To use the spreadsheet, enter the future value of the annuily in cell B10 (using value from part (a), rounded to the nearest cent). As you did in part (a), enter the interest per period in B11 (as above, do not round this value). Then enter the total number of period (l.e., total number of payments) in B12. The payment will display in B13. Vamsen Savings and Loan will require a quarterly payment of \$ (round to the nearest cent) in their loan repayment contract with Pennypacker. (e) From the list below, identify the formula used by the spreadsheet to compute the answer to part (d). A. F=P(1+rt) B. F=Per1 C. F=()P((1+)w1) D. F=P(1+nr)st E. rB=(1+nn)n1 F. None of these (t) Fill in the blanks below with the values that should be used for each variable in the formula chosen in part (e). if a letter is listed that is not part of the formula, enter "NONE" in the blank. n=t=Fr= tine. Then, he will make pre-determined fixed quarterly payments (one payment every 3 months) for the full 20 year term of the loan agreement. These a eferred to as amortization payments. The amount of each payment will be the amount found above in part (d). Determine all of the following information about Pennypacker's ioan. For each step, use the value of the payment rounded to the nearest cent. Total value of the mine (amount of original loan) is $ Pennypacker's quarterly amortization payments will each be $ The total number of amortization payments over the 20 year term will be The total amount that Pennypacker will pay back to Vamsen Savings and Loan over the full 20 years will be $ The total amount of interest that Pennypacker will pay over the term of the loan will be $ (h) Determine the amount Pennypacker will have paid on his loan at the end of 10 years and the amount that will stil be owed at that time. Total value of the mine is $ Total amount paid at the end of 10 years will be $ (to the nearest cent) Total amount stili owed on the loan at the end of 10 years will be $ (to the nearest cent) Thus, after 10 years, Pennypacker's equity in the mine is $ (to the nearest cent). In other words, Pennypacker's equity in the silver mine is \% (round percent to 3 decimal places) ater 10 years. (i) Before going to sign the papers, Pennypacker wanted to know what his payment amount was going to be. To heip, his frend Art vandelay showed him a "loan payoff formula" that may also be used to compute a fixed loan payment P, using the other varlables above and the original loan amount. Here is their calculation: LoanAmount=P(n1(1+n)at)$276,078,500=P(40.02761(1+40.0976)429)
