Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need the execel functions pls Consider the following information and answer each of the questions below using arithmetic, algebra, and Excel functions as appropriate.

i need the execel functions plsimage text in transcribedimage text in transcribed

Consider the following information and answer each of the questions below using arithmetic, algebra, and Excel functions as appropriate. Larz is considering an ARM loan offered by a local lender. The loan amount is $585,000. The term of the loan is 10 years. The margin on the loan is 3%. The teaser (first year only) is 1%. The composite rate adjusts annually and is subject to annual and lifetime caps of 2% and 5%, respectively. The loan does not provide for negative amortization nor does it provide floors. Assume the following forecast of index rates. The prevailing rate in the market for similar FRM loans is 5.25%. Make no changes to this Excel workbook other than entering information needed in the yellow and pink highlighted cells and your answer calculation in the green highlighted cells. Only the green highlighted cells will be graded. Do not round intermediate calculations (let Excel store all decimal values). 5. What is the payment in months 25 through 36? Loan Balance Remaining Loan Term (years) Payments per Year Composite Rate 6. What is the balance at the EOY 3 ? \begin{tabular}{|l|l|l|} \hline Payment & Balance \\ \hline Composite Rate \\ \hline Remaining Loan Term (years) \\ \hline Payments per Year & \\ \hline 7. What is the payment in months 37 through 48? & Payment \\ \hline Loan Balance & \\ \hline Remaining Loan Term (years) & \\ \hline Payments per Year & \\ \hline Composite Rate & \\ \hline & & \\ \hline P. What is the balance at the EOY 4? & \\ \hline Payment & & \\ \hline Composite Rate & \\ \hline Remaining Loan Term (years) & \\ \hline Payments per Year & \\ \hline \end{tabular} Consider the following information and answer each of the questions below using arithmetic, algebra, and Excel functions as appropriate. Larz is considering an ARM loan offered by a local lender. The loan amount is $585,000. The term of the loan is 10 years. The margin on the loan is 3%. The teaser (first year only) is 1%. The composite rate adjusts annually and is subject to annual and lifetime caps of 2% and 5%, respectively. The loan does not provide for negative amortization nor does it provide floors. Assume the following forecast of index rates. The prevailing rate in the market for similar FRM loans is 5.25%. Make no changes to this Excel workbook other than entering information needed in the yellow and pink highlighted cells and your answer calculation in the green highlighted cells. Only the green highlighted cells will be graded. Do not round intermediate calculations (let Excel store all decimal values). 5. What is the payment in months 25 through 36? Loan Balance Remaining Loan Term (years) Payments per Year Composite Rate 6. What is the balance at the EOY 3 ? \begin{tabular}{|l|l|l|} \hline Payment & Balance \\ \hline Composite Rate \\ \hline Remaining Loan Term (years) \\ \hline Payments per Year & \\ \hline 7. What is the payment in months 37 through 48? & Payment \\ \hline Loan Balance & \\ \hline Remaining Loan Term (years) & \\ \hline Payments per Year & \\ \hline Composite Rate & \\ \hline & & \\ \hline P. What is the balance at the EOY 4? & \\ \hline Payment & & \\ \hline Composite Rate & \\ \hline Remaining Loan Term (years) & \\ \hline Payments per Year & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Budgets And Financial Management In Higher Education

Authors: Margaret J. Barr, George S. McClellan

3rd Edition

1119287731, 9781119287735

More Books

Students also viewed these Finance questions