Consider the following information and answer each of the questions below using arithmetic, algebra, and Excel...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the following information and answer each of the questions below using arithmetic, algebra, and Excel functions as appropriate. Lary is considering an ARM loan offered by a local lender. The loan amount is $385,000. The term of the loan is 10 years. The index today is 1.1%. The margin on the loan is 3%. The teaser (first year only) is 1%. The E composite rate adjusts annually and is subject to annual and lifetime caps of 2% and 5%. 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 s 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 0 highlighted cells will be graded. Do not round intermediate caleulations (let Excel store all decimal values). Index Rate Composite 14 Year Forecast Rate 1.10% 2.25% 16 17 18 19 20 2. 2.50% 3.10% 4 4,00% 7.50% 21 5.50% 22 7. 7.50% 23 8. 8.00% 24 9. 4.10% 25 26 61 23 5. What is the payment in months 25 through 36? Loan Balance Loan Term (years) Payments per Year Composite Rate Payment 6. What is the balance at the EOY 3? Payment Composite Rate Loan Term (years) Payments per Year Balance 7. What is the payment in months 37 through 48? Loan Balance Loan Term (years) Payment Payments per Year Composite Rate I8. What is the balance at the EOY 4? e Payment S Composite Rate 4 Loan Term (years) 5 Payments per Year Balance Consider the following information and answer each of the questions below using arithmetic, algebra, and Excel functions as appropriate. Lary is considering an ARM loan offered by a local lender. The loan amount is $385,000. The term of the loan is 10 years. The index today is 1.1%. The margin on the loan is 3%. The teaser (first year only) is 1%. The E composite rate adjusts annually and is subject to annual and lifetime caps of 2% and 5%. 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 s 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 0 highlighted cells will be graded. Do not round intermediate caleulations (let Excel store all decimal values). Index Rate Composite 14 Year Forecast Rate 1.10% 2.25% 16 17 18 19 20 2. 2.50% 3.10% 4 4,00% 7.50% 21 5.50% 22 7. 7.50% 23 8. 8.00% 24 9. 4.10% 25 26 61 23 5. What is the payment in months 25 through 36? Loan Balance Loan Term (years) Payments per Year Composite Rate Payment 6. What is the balance at the EOY 3? Payment Composite Rate Loan Term (years) Payments per Year Balance 7. What is the payment in months 37 through 48? Loan Balance Loan Term (years) Payment Payments per Year Composite Rate I8. What is the balance at the EOY 4? e Payment S Composite Rate 4 Loan Term (years) 5 Payments per Year Balance
Expert Answer:
Answer rating: 100% (QA)
The initial composite rate initial rate index rate 1 110 ... View the full answer
Related Book For
Cornerstones of Financial and Managerial Accounting
ISBN: 978-0324787351
1st Edition
Authors: Rich Jones, Mowen, Hansen, Heitger
Posted Date:
Students also viewed these accounting questions
-
Consider the following information and answer the questions. a. Calculate the expected return of each stock. b. Calculate the variance and standard deviation of each stock. c. Calculate the expected...
-
Consider the following information on three stocks: a. If your portfolio is invested 30 percent each in A and B and 40 percent in C, what is the portfolio expected return? The variance? The standard...
-
Consider the following information about an end product item: Ordering cost = $90/order Annual demand = 936 Inventory carrying cost = $2/unit/week. (Notice the unit change) a. How many orders should...
-
Dr. Thomas Bilski is a primary care physician with a practice that is currently serving 280 patients. Dr. Bilski would like to administer a survey to his patients to measure their satisfaction levels...
-
How do currency forward and futures contracts differ with respect to maturity, settlement, and the size and timing of cash flows?
-
Discuss (with examples) how DFMEA might be used in a service application rather than in a pure product design application.
-
With reference to the Example 3 concerning improvements in the safety of an ignitor, the time to reach maximum pressure was also recorded. Two replicates were run of the factorial design and the...
-
If the U.S. dollar were to appreciate substantially, what steps could a domestic manufacturer like Cummins Engine Co. of Columbus, Indiana, take in advance to reduce the effect of the exchange rate...
-
Find the length of the curve (t)=(9,,) for-3
-
During 2020, Richard and Greta Van Fleet, who are married and have two dependent children, ages 14 and 16, and have the following information: Total salaries Bank account interest State of Idaho bond...
-
Finance Problems 1) What is the initial outlay, given the following information: Equipment Price. $375,000 Installation. 10,000 Power Survey 30,000 Shipping. 8,000 Working Capital 100,000 Project...
-
The Rydberg equation gives us the mathematical relationship between: A) an explanation for the continuous range of energy values associated with atomic spectra B) wavelength and frequency C) electron...
-
18. If 5.0 moles of calcium reacts with excess oxygen as shown, 2 Ca(s) + O2(g) 2CaO(s) AHxn= -1,270 kJ a. The reaction releases 6,350 kJ. b. The reaction absorbs 6,350 kJ. c. The reaction releases...
-
When aluminum is placed in concentrated hydrochloric acid, hydrogen gas is produced. 2 Al(s) + 6 HCl(aq) ->> 2 AICI, (aq) + 3 H(g) What volume of H(g) is produced when 7.20 g Al(s) reacts at STP?...
-
Draw a roadmap and write a plan to find the mass ( g ) of the products based on the given amount of reactants. 2 H 2 O 2 - > 2 H 2 O + O 2 given: H 2 O 2 = 4 9 . 4 mg
-
Calculation: In lab, you are given a protein stock that is 7 mg/ml. You want to add 60 ug of this protein to your reaction tube. What volume do you need to pipette of the stock into your reaction...
-
Solve the system. State whether the system is inconsistent or has infinitely many solutions. If the system has infinitely many solutions, write the solution set with y arbitrary. 3x-4y=4 -6x+8y=-8...
-
Time Solutions, Inc. is an employment services firm that places both temporary and permanent workers with a variety of clients. Temporary placements account for 70% of Time Solutions' revenue;...
-
Name and describe two kinds of leases.
-
What is a 10-K?
-
Why are inventories written down to the lower of cost or market?
-
Suppose a bond is taxable for both federal and state purposes. Let Rb = the BTROR on the bond, tfed = the federal tax rate, and tst = the state tax rate. Determine the ATROR (i.e., after federal and...
-
Under what conditions are the Exempt Model and Pension Model equivalent? Under what conditions would one model perform better than the other? How does the \($6,500\) limitation on deductible and Roth...
-
Consider three taxpayers who are in the following tax brackets: Alice 25% Brad 35% Camille 40%
Study smarter with the SolutionInn App