In this part of the assignment, you are required to prepare a loan repayment schedule for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
In this part of the assignment, you are required to prepare a loan repayment schedule for a mortgage loan you borrowed from the bank. The loan is to be repaid by equal month-end repayments starting from the end of the first month. The monthly repayments include both the interest and the principal of the loan (P&I). The term of the loan is n years. Complete the table below showing the variables you need for the loan repayment schedule Student number digit by digit 4 6 3 2 4 631 Number of years you have to repay the loan, n. Number of months you have to repay the loan, nm Nominal annual Interest rate p.a compounded monthly (m) Effective monthly interest rate (i=j_/m) Original loan amount Fixed monthly repayment (P&I) amount DO NOT Round any amounts in the Amortisation Schedule. Use format commands to display as currency. Loan Amortisation Schedule Interest paid Balance at the beginning of month Principal paid Month 1 2 7.00% $927,262 Answer must be positive (greater than 0) Balance at the end of month Based on your amortisation schedule, calculate answers to Q1 to Q7 in the highlighted cells below using excel TVM functions and referencing the relevant cells in worksheet 'Amortisation Schedule'. Answer each question using AT LEAST ONE of Excel's TVM functions from among =PV, =FV, =PMT, =RATE, =NPER, = IPMT, =PPMT, =CUMIPMT, CUMPRINC. Question 5 to Question 9 are new independent scenarios which are not related to each other. For all the questions below, your answer must be positive (greater than 0). Do NOT round your answer (unless required by the questions) but format as dollars and cents or percentages if necessary. Do NOT include any words such as "months" in your answer. Q1 (0.5 02 (0.5 Q3 (0.5 Calculate the amount of principal paid in the month 30. Calculate the total amount of interest paid from the beginning of month 60 to the end of month 90. Calculate the amount of the loan outstanding balance at the end of month 45. Q4 (1 mark) At the end of which month will it be for the loan outstanding balance to be less than 60% of the original loan amount for the first time? Useful clue: Which function gives the number of time periods? Think about the rounding rules for the final answer. Roundup or rounddown? Remember you can check your answer in the amortisation In this part of the assignment, you are required to prepare a loan repayment schedule for a mortgage loan you borrowed from the bank. The loan is to be repaid by equal month-end repayments starting from the end of the first month. The monthly repayments include both the interest and the principal of the loan (P&I). The term of the loan is n years. Complete the table below showing the variables you need for the loan repayment schedule Student number digit by digit 4 6 3 2 4 631 Number of years you have to repay the loan, n. Number of months you have to repay the loan, nm Nominal annual Interest rate p.a compounded monthly (m) Effective monthly interest rate (i=j_/m) Original loan amount Fixed monthly repayment (P&I) amount DO NOT Round any amounts in the Amortisation Schedule. Use format commands to display as currency. Loan Amortisation Schedule Interest paid Balance at the beginning of month Principal paid Month 1 2 7.00% $927,262 Answer must be positive (greater than 0) Balance at the end of month Based on your amortisation schedule, calculate answers to Q1 to Q7 in the highlighted cells below using excel TVM functions and referencing the relevant cells in worksheet 'Amortisation Schedule'. Answer each question using AT LEAST ONE of Excel's TVM functions from among =PV, =FV, =PMT, =RATE, =NPER, = IPMT, =PPMT, =CUMIPMT, CUMPRINC. Question 5 to Question 9 are new independent scenarios which are not related to each other. For all the questions below, your answer must be positive (greater than 0). Do NOT round your answer (unless required by the questions) but format as dollars and cents or percentages if necessary. Do NOT include any words such as "months" in your answer. Q1 (0.5 02 (0.5 Q3 (0.5 Calculate the amount of principal paid in the month 30. Calculate the total amount of interest paid from the beginning of month 60 to the end of month 90. Calculate the amount of the loan outstanding balance at the end of month 45. Q4 (1 mark) At the end of which month will it be for the loan outstanding balance to be less than 60% of the original loan amount for the first time? Useful clue: Which function gives the number of time periods? Think about the rounding rules for the final answer. Roundup or rounddown? Remember you can check your answer in the amortisation
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
In this task, you are required to prepare a tax case analysis based on the recent controversial hearing on ABS-CBN's franchise renewal in the Philippines. You are required to state the facts and make...
-
You are required to prepare a strategy implementation plan based on your companys strategic position assigned to you by your lecturer. You will be assigned the following generic strategy positions:...
-
You are required to prepare two written responses: 1) tax file memorandum and 2) client letter. For the tax memorandum file, use exhibit 2.9 on page 2-27 for an example
-
The simple truss shown has the following dimensions: H1 = 1.90 in; H2 = 1.60 in; L0=31 in; L2 = 14 in; D1 = 0.76 in; D2 = 0.86 in. Both supporting bars have a depth of 0.5 in. If the maximum...
-
A summary of the assets and equities of Pot Corporation and its 80 percent-owned subsidiary, Sea Corporation, at December 31, 2011, is given as follows (in thousands): On January 2, 2012, Sea...
-
Problem 2a (10 points): 2 N-s/m 6 N/m 00004 kg x(t) 2 N-s/m 4 kg x2(t) 0000 6 N/m 4 kg X3(1) 2 N-s/m -f(t) Frictionless 1. Draw free body diagrams for each mass (4 points) 2. Write the equations of...
-
Indicate which type of data analytics, 1 through 4, is described in each of the following statements, a through \(h\). Data Analytics 1. Descriptive analytics 2. Diagnostic analytics 3. Predictive...
-
The trial balance of Terry Manning Fashion Center contained the following accounts at November 30, the end of the companys fiscal year. Adjustment data: 1. Store supplies on hand totaled $2,500. 2....
-
Inverse of 1 x l n ( 2 e x + 3 )
-
Determine the force in members GF, CF, and CD of the roof truss and indicate if the members are in tension or compression. 1.5 kN 1.70 m 2 kN 1.5 m 0,8 m G. -1 m- 2 m 2 m
-
Let f(x) = (9x7 - 5x6)In(4x). Compute f'(x). f'(x) =
-
What is the viewpoint of someone nicknamed a NIMBY?
-
Some argue that a crowd of amateurs is often smarter than a group of industry experts when predicting future changes in technology. Why might this be true?
-
It is said that a delay in critical path activity will delay the project, while a delay in a noncritical path activity will not necessarily delay the project. Explain the need to specify not...
-
Assuming a 360-day year, calculate how much the average investment in inventory would be for Temasek Holdings, a company based in Singapore, given the following information in each case. a. The firm...
-
How does a NIMBY argument potentially relate to the issues of productivity and sustainability?
-
Was the First Juvenile Court in the World in Canada? As in the United States, the development of a separate juvenile justice system in Canada was linked with the Child Savers Movement. In 1857, two...
-
Write out the formula for the total costs of carrying and ordering inventory, and then use the formula to derive the EOQ model. Andria Mullins, financial manager of Webster Electronics, has been...
-
Steve Jackson (age 51) is a single taxpayer living at 3215 Pacific Dr., Del Mar, CA 92014. His Social Security number is 465-88-9415. In 2012, Steve's earnings and income tax withholding as the...
-
Russell (age 50) and Linda (age 45) Long have brought you the following information regarding their income and expenses for the current year. Russell owns and operates a landscaping business called...
-
Fisafolia Corporation has gross income from operations of $220,000 and operating expenses of $160,000 for 2012. The corporation also has $20,000 in dividends from publicly traded domestic...
-
What do you understand by the term monetary policy?
-
Define open market operations by a central bank.
-
Explain monetary base, required reserves and excess reserves.
Study smarter with the SolutionInn App