Question #1: On paper create an amortization schedule for a 5 years car loan of $5,000...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question #1: On paper create an amortization schedule for a 5 years car loan of $5,000 at 9% interest. List the six headings and show the work. b. For the life of the loan, calculate: i. The total payments made: ii. Total interest paid: iii. Total principal paid: iv. Why is the total payment more than the amount borrowed initially? Question #2: Real life application: Buying a House Using an excel template, create an amortization schedule for a $500,000 house assuming 20% down payment, 4% interest for 30 years with monthly payments. Note: Insert the data in the top left hand corner of the Excel Sheet. Link with formulas Calculation at 4% interest: a. How much is the down payment? c. Monthly payments b. List the steps to get the monthly payment amount i. List financial calculator keys b. What is the loan amount? ii. List Excel steps C. For the life of the loan, list the : i. Total payments made: ii. Total interest paid: iii. Total principal paid: Question #3. Now, let's assume due to poor credit the mortgage rate increased from 4% to 8%. a. How much will be the monthly payments? paid in the life of the loan? b. What is the total interest 3. What advise can you give a prospective homeowner who hopes to buy the house. a. b. C. Question #1: On paper create an amortization schedule for a 5 years car loan of $5,000 at 9% interest. List the six headings and show the work. b. For the life of the loan, calculate: i. The total payments made: ii. Total interest paid: iii. Total principal paid: iv. Why is the total payment more than the amount borrowed initially? Question #2: Real life application: Buying a House Using an excel template, create an amortization schedule for a $500,000 house assuming 20% down payment, 4% interest for 30 years with monthly payments. Note: Insert the data in the top left hand corner of the Excel Sheet. Link with formulas Calculation at 4% interest: a. How much is the down payment? c. Monthly payments b. List the steps to get the monthly payment amount i. List financial calculator keys b. What is the loan amount? ii. List Excel steps C. For the life of the loan, list the : i. Total payments made: ii. Total interest paid: iii. Total principal paid: Question #3. Now, let's assume due to poor credit the mortgage rate increased from 4% to 8%. a. How much will be the monthly payments? paid in the life of the loan? b. What is the total interest 3. What advise can you give a prospective homeowner who hopes to buy the house. a. b. C.
Expert Answer:
Related Book For
Intermediate Accounting
ISBN: 978-0470161012
9th Canadian Edition, Volume 2
Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield.
Posted Date:
Students also viewed these finance questions
-
Use the following information for MFB, Inc. for this problem. MSB Inc.Assets Current assetsCash11,560Accounts receivable9,200Inventory 15,500 Total36,260Fixed assetsNet plant and equipment50,164Total...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Question: Old MathJax webview Old MathJax webview i need ans of these question but the source is alot Old MathJax webviewOld MathJax webview i need ans of these question but the source is alot these...
-
Within the context of the planning cycle, the planning that takes place at the highest levels of the firm is called: A. detailed planning and control. B. strategic planning. C. operational planning....
-
In a photoelectric experiment a student uses a light source whose frequency is greater than that needed to eject electrons from a certain metal. However, after continuously shining the light on the...
-
(a) Does it make sense to talk about a dielectric constant for a conductor? If so, what value does the constant have? (b) What is the breakdown threshold for a conductor?
-
4. CPA QUESTION Which of the following factors is least important in determining whether a manufacturer is strictly liable in tort for a defective product? a. The negligence of the manufacturer b....
-
Fallow Co. had the following transactions during the current period. Mar. 2 Issued 5,000 shares of $1 par value common stock to attorneys in payment of a bill for $38,000 for services provided in...
-
i tried option A and last option nut both of them are wrong . For firms with good projects and high dividend payouts, managers must be concerned with: a negative reaction to a cut In dividends O the...
-
Complete the payroll register for this pay period and update the Employee Earnings Record form for each employee with the corresponding information. The Step-2 of Form W-4 is unchecked. The amount...
-
The Company has a loan due to the bank that requires monthly payments of interest based on a 360 day calendar year. Please answer the following questions: Debt Balance at September 1st: $2,000,000...
-
Recommend 3 strategies to evaluate the business impact of change and sustain change efforts through performance management. Recommend 4 best practices for ensuring the application of new skills and...
-
Phoenix Company reports the following fixed budget. It is based on an expected production and sales volume of 15,100 units. Sales Costs PHOENIX COMPANY Fixed Budget For Year Ended December 31 Direct...
-
Factor completely: x +3x-10=(x+a)(x-b). What is the value of the coefficient a?
-
Select a print, broadcast, or online source of global, national, or local news.-https://www.cnbc.com/2022/12/07/mcdonalds-seasonal-promotions-digital-sales-growth.html Use this publication to select...
-
1. How many distinct IPv4 addresses exist? Show your calculations. 2. An ambitious McGill student devises a new IP address that has the following format: A.B.C.D.E.F.G.H- where each letter...
-
A strong environmental commitment is beneficial to the motivation of the employees as well as creating a competitive advantage in the marketplace by effectively differentiating its products. How can...
-
A firm has the following balance sheet: Assets Cash Accounts receivable Inventory Plant and equipment $ 15,000 150,000 92,000 170,000 $427,000 Liabilities and Equity Accounts payable Long-term debt...
-
Sarazan Corp. purchased a $1-million, four-year, 7.5% fixed-rate interest only, non-prepayable bond on December 31, 2011. The bond is actively traded and is held as a fair value through net income...
-
Manon Corporation sponsors a defined benefit pension plan, which it accounts for with the deferral and amortization approach. The following pension plan information is available for 2011 and 2012:...
-
Makins Ltd. purchased a machine on January 1, 2009, for $1,350,000. At that time, it was estimated that the machine would have a 10-year life and no residual value. On December 31, 2012, the firms...
-
For each of the flows in Problems 1 and 2, for which an irregular structured grid has been found necessary and possible, suggest a coordinate transformation.
-
Consider the primitive LES and RANS models, in which the eddy viscosity formulas (11.32) and (11.77) are applied with constant eddy viscosity \(\mu_{t}\). What is the drawback of these models? Should...
-
If your course involves exercises with CFD software, study the documentation to determine whether the LES option is implemented. Which closure models are used? What approach is taken to the near-wall...
Study smarter with the SolutionInn App