Excel Module 2

profilejymojica
SC_EX16_4b_JesusMojica_1.xlsx
Home>Information Systems homework help>Excel Module 2

Documentation

Shelly Cashman Excel 2016 | Module 4: SAM Project 1b
PT Associates
FINANCIAL FUNCTIONS, DATA TABLES, AND AMORTIZATION SCHEDULES
Author: Jesus Mojica
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

Clinic Mortgage

PT Associates
Mortgage Loan Payment Calculator Amortization Schedule
Date 15-Aug-18 Rate 5.250% Year Beginning Balance Ending Balance Paid on Principal Interest Paid
Item Clinic Term (Years) 15 1 $ 300,000.00 $ 286,488.35
Price $ 375,000.00 Monthly Payment 2 $ 286,488.35 $ 272,250.02
Down Payment $ 75,000.00 Total Interest $ (300,000.00) 3 $ 272,250.02 $ 257,245.93
Loan Amount $ 300,000.00 Total Cost $ 75,000.00 4 $ 257,245.93 $ 241,434.89
5 $ 241,434.89 $ 224,773.50
Varying Interest Rate Schedule 6 $ 224,773.50 $ 207,216.03
Rate Monthly Payment Total Interest Total Cost 7 $ 207,216.03 $ 188,714.29
8 $ 188,714.29 $ 169,217.49
3.000% 9 $ 169,217.49 $ 148,672.11
3.250% 10 $ 148,672.11 $ 127,021.76
11 $ 127,021.76 $ 104,207.02
12 $ 104,207.02 $ 80,165.26
13 $ 80,165.26 $ 54,830.48
14 $ 54,830.48 $ 28,133.16
15 $ 28,133.16 $ - 0
Subtotal $ - 0 $ - 0
Down Payment
Total Cost $ - 0

Outstanding Loans

PT Associates
Loan Type Car Equipment Condominium College
Year Borrowed 2014 2011 2010 2006
Price $ 25,000.00 $ 70,000.00 $ 300,000.00 $ 80,000.00
Loan Amount $ 20,000.00 $ 55,000.00 $ 240,000.00 $ 60,000.00
Rate 5.255% 6.359% 4.586% 2.550%
Term (Years) 5 10 30 15
Monthly Payment $ 379.77 $ 620.58 $ 1,228.34 $ 401.49
Total Interest
Total Cost $ 25,000.00 $ 70,000.00 $ 300,000.00 $ 80,000.00
Current Year of Loan 4 7 8 12
Loan Balance at End of Current Year