+ Terms: I Period 1 use an excel spreadsheet using the same format as the example...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
+ Terms: I Period 1 use an excel spreadsheet using the same format as the example below: 2 Amortize the following loan -- 3 4 5 6 Loan Amount Interest rate Term Rate (annual) => Loan Amount=> Term (years)=> Payment (monthly)=> Loan Amortization Beginning Balance $25,000.00 $24,641.68 $24,281.57 $23,919.66 $23,555.93 $23,190.39 6.00% $ 25,000.00 5 $483.32 Payment $483.32 $50,000 6.0% 5 yrs Payments are monthly $483.32 $483.32 $483.32 $483.32 $483.32 Interest $125.00 $123.21 $121.41 $119.60 $117.78 $115.95 Principal $358.32 $360.11 $361.91 $363.72 $365.54 $367.37 End Balance $24,641.68 $24,281.57 $23,919.66 $23,555.93 $23,190.39 $22,823.03 Period 1 2 3 4 5 6 7 8 9 10 11 12 Loan Amortization Beginning Balance $25,000.00 $24,641.68 $24,281.57 $23,919.66 $23,555.93 $23,190.39 $22,823.03 $22,453.82 $22,082.77 $21,709.86 $21,335.09 $20,958.45 Payment $483.32 $483.32 $483.32 $483.32 $483.32 $483.32 $483.32 $483.32 $483.32 $483.32 $483.32 $483.32 Interest $125.00 $123.21 $121.41 $119.60 $117.78 $115.95 $114.12 $112.27 $110.41 $108.55 $106.68 $104.79 Principal $358.32 $360.11 $361.91 $363.72 $365.54 $367.37 $369.20 $371.05 $372.91 $374.77 $376.64 $378.53 End Balance $24,641.68 $24,281.57 $23,919.66 $23,555.93 $23,190.39 $22,823.03 $22,453.82 $22,082.77 $21,709.86 $21,335.09 $20,958.45 $20,579.92 Period 1 =B14+1 =B15+1 =B16+1 =B17+1 =B18+1 =B19+1 =B20+1 =B21+1 =B22+1 =B23+1 Rate (annual)=> Loan Amount => Term (years) => Payment (monthly)=> Loan Amortization Beginning Balance =F5 =L14 =L15 =L16 =L17 =L18 =L19 =L20 =L21 =L22 =L23 =PMT(F4/12,F6*12, F5)*-1 Payment 0.06 25000 5 =F8 =F14 =F15 =F16 =F17 =F18 =F19 =F20 =F21 =F22 =F23 Interest =D14* ($F$4/12) =D15*($F$4/12) =D16*($F$4/12) =D17*($F$4/12) =D18*($F$4/12) =D19* ($F$4/12) =D20* ($F$4/12) =D21*($F$4/12) =D22* ($F$4/12) =D23* ($F$4/12) =D24*($F$4/12) Principal =F14-H14 =F15-H15 =F16-H16 =F17-H17 =F18-H18 =F19-H19 =F20-H20 =F21-H21 =F22-H22 =F23-H23 =F24-H24 End Balance =D14-J14 =D15-J15 =D16-J16 =D17-J17 =D18-J18 =D19-J19 =D20-J20 =D21-J21 =D22-J22 =D23-J23 =D24-J24 You must include the following information on your spreadsheet: All columns as indicated above. All calculations must use excel formulas within the spreadsheet (do not insert numbers you calculated on your calculator). The loan should be fully amortized (60 periods). Submit your excel spreadsheet to the dropbox named Amort Project on D2L with the name as: 3710 SP 20 Amort Project "last name" on first page as title. - + Terms: I Period 1 use an excel spreadsheet using the same format as the example below: 2 Amortize the following loan -- 3 4 5 6 Loan Amount Interest rate Term Rate (annual) => Loan Amount=> Term (years)=> Payment (monthly)=> Loan Amortization Beginning Balance $25,000.00 $24,641.68 $24,281.57 $23,919.66 $23,555.93 $23,190.39 6.00% $ 25,000.00 5 $483.32 Payment $483.32 $50,000 6.0% 5 yrs Payments are monthly $483.32 $483.32 $483.32 $483.32 $483.32 Interest $125.00 $123.21 $121.41 $119.60 $117.78 $115.95 Principal $358.32 $360.11 $361.91 $363.72 $365.54 $367.37 End Balance $24,641.68 $24,281.57 $23,919.66 $23,555.93 $23,190.39 $22,823.03 Period 1 2 3 4 5 6 7 8 9 10 11 12 Loan Amortization Beginning Balance $25,000.00 $24,641.68 $24,281.57 $23,919.66 $23,555.93 $23,190.39 $22,823.03 $22,453.82 $22,082.77 $21,709.86 $21,335.09 $20,958.45 Payment $483.32 $483.32 $483.32 $483.32 $483.32 $483.32 $483.32 $483.32 $483.32 $483.32 $483.32 $483.32 Interest $125.00 $123.21 $121.41 $119.60 $117.78 $115.95 $114.12 $112.27 $110.41 $108.55 $106.68 $104.79 Principal $358.32 $360.11 $361.91 $363.72 $365.54 $367.37 $369.20 $371.05 $372.91 $374.77 $376.64 $378.53 End Balance $24,641.68 $24,281.57 $23,919.66 $23,555.93 $23,190.39 $22,823.03 $22,453.82 $22,082.77 $21,709.86 $21,335.09 $20,958.45 $20,579.92 Period 1 =B14+1 =B15+1 =B16+1 =B17+1 =B18+1 =B19+1 =B20+1 =B21+1 =B22+1 =B23+1 Rate (annual)=> Loan Amount => Term (years) => Payment (monthly)=> Loan Amortization Beginning Balance =F5 =L14 =L15 =L16 =L17 =L18 =L19 =L20 =L21 =L22 =L23 =PMT(F4/12,F6*12, F5)*-1 Payment 0.06 25000 5 =F8 =F14 =F15 =F16 =F17 =F18 =F19 =F20 =F21 =F22 =F23 Interest =D14* ($F$4/12) =D15*($F$4/12) =D16*($F$4/12) =D17*($F$4/12) =D18*($F$4/12) =D19* ($F$4/12) =D20* ($F$4/12) =D21*($F$4/12) =D22* ($F$4/12) =D23* ($F$4/12) =D24*($F$4/12) Principal =F14-H14 =F15-H15 =F16-H16 =F17-H17 =F18-H18 =F19-H19 =F20-H20 =F21-H21 =F22-H22 =F23-H23 =F24-H24 End Balance =D14-J14 =D15-J15 =D16-J16 =D17-J17 =D18-J18 =D19-J19 =D20-J20 =D21-J21 =D22-J22 =D23-J23 =D24-J24 You must include the following information on your spreadsheet: All columns as indicated above. All calculations must use excel formulas within the spreadsheet (do not insert numbers you calculated on your calculator). The loan should be fully amortized (60 periods). Submit your excel spreadsheet to the dropbox named Amort Project on D2L with the name as: 3710 SP 20 Amort Project "last name" on first page as title. -
Expert Answer:
Answer rating: 100% (QA)
Here is the amortization schedule with stepbystep workings Rate annual 600 Loan Amount 500000... View the full answer
Related Book For
Intermediate Accounting
ISBN: 978-0132162302
1st edition
Authors: Elizabeth A. Gordon, Jana S. Raedy, Alexander J. Sannella
Posted Date:
Students also viewed these finance questions
-
In this game, students fence off an area of the drill field and divide it up into a series of equally sized squares. (We will assume there are 500 such squares organized into a 20 by 25 matrix.) Each...
-
The raw data for Problem 22, from Freund (1979), appear below. For the model of Problem 22, a. Fit the model. b. What discrepancies do you note between the results of (a) and the data summary...
-
Calculate the discount period for the bank to wait to receive its money: (Use Days in a year table): Date of note Length of note Date note discounted Discount period May 15 50 days June 6 days Solve...
-
8 D D D D P P P P P P P P P P P 10 Functions What is defusion. What is osnosis What is Tornicity The power house of the cell functions of the plasma? What is facilitated defusion? do they need ATP?...
-
Suppose Piranha.com sells 2,500 books on account for $15 each (cost of these books is $22,500) on October 10, 2012. One hundred of these books (cost $900) were damaged in shipment, so Piranha.com...
-
Which of the following is the appropriate null hypothesis for performing a chi-square test? a. Equal proportions of female and male teenagers are almost certain they will be married in 10 years. b....
-
How many salespeople are required?
-
Certain production equipment used by Dayton Mechanical has become obsolete relative to current technology. The company is considering whether it should keep or replace its existing equipment. To aid...
-
In the case of the plucked string, use the formula for Fourier sine coefficients to show that Am 2h sin mp m p(x-p For what position of p are the second, fourth, ... harmonics missing? For what...
-
Diana acquires, for $65,000, and places in service a 5-year class asset on December 19, 2022. It is the only asset that Diana acquires during 2022. Diana does not elect immediate expensing under ...
-
Which of these was NOT identified as a problem with Tesco's failed expansion into the U.S. market? OA) U.S. consumers weren't interested in fresh and healthy foods. B) Stores weren't properly...
-
Nonverbal - Skeleton Name____________________________________ The purpose of this assignment is to help you demonstrate the following Student Learning Outcome(s) 1. Demonstrate and explain an...
-
Company Name Net debt + pfd equity + minority int Enterprise value Number of shares Stock price Earnings / share EBITDA Revenue EBIT Book value / share Peer Bloomin' Brands, Inc. (NasdaqGS:BLMN)...
-
Question 1 Use the following tab to answer below question: Question 1 - Data Required: Please prepare the bank reconciliation as of February 28, 2023 for the two...
-
Garden City Company changed from an accounting principle that is not generally accepted to one that is generally accepted. How should the effect of the change be reported? Explain
-
Title: Comprehensive Exploration of Accounting: Transaction, Assets, Goodwill, and Liabilities I. Introduction Accounting serves as the backbone of financial management, providing a systematic...
-
Briefly discuss how the organisation would establish and evaluate the feasibility of the project described in the introduction to this assignment. Discuss the following in your response: Tools to...
-
What recommendations would you make to Big Four firms to help them (1) avoid confrontations with governmental officials in an authoritarian society and (2) deal effectively with such confrontations...
-
Sodesta Company offers volume discounts to its customers. Customers buying over $ 100,000 receive a 1% discount. Customers buying over $ 200,000 receive a 3% discount. Sodesta also offers sales...
-
Using the information provided in BE5- 13, report comprehensive income in a separate statement of comprehensive income. In BE5-13 Steven Stores, Inc. Statement of Net Income For the Year Ended...
-
Using the information in BE8- 13, indicate how Sycamore should allocate the transaction price to the three products using the expected- cost- plus- a- margin approach. In BE-13 Market Standalone...
-
Does the fact that selling is included as part of the promotional mix weaken or strengthen its role as a sub-element of marketing?
-
Discuss the role and function of selling.
-
Comment on why the proposed changes to sales processes are necessary. Also, which changes would you recommend in terms of their: (a) selling activities? (b) sales value proposition?
Study smarter with the SolutionInn App