Documentation
Shelly Cashman Excel 2019 | Module 4: SAM Project 1a
Smith & Lyngate Insurance
CREATE A LOAN ANALYSIS
Author: FATEMATUZ ZAHARA
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.
Loan Calculato
New Office Building
Loan Calculato
Loan Payment Calculator Scenarios Renovation 20 Years 8 Years
Date 9/15/21 Rate 4.45% Loan Amount $ 1,020,000 $ - 0
Property Charles Street Term in Months 180 Annual Interest Rate 4.45% 4.25% 4.45%
Price $ 1,150,000 Monthly Payment Monthly Interest Rate 0.37% 0.35% 0.37%
Down Payment $ 230,000 Total Interest Loan Period in Years 15 20 8
Loan Amount Total Cost Loan Period in Months 180 240 96
Start Date 1/3/22 1/3/22 1/3/22
Varying Interest Rates and Terms Monthly Payment $ (6,000) $ (8,000)
Rate Number of Months Future Value n/a n/a
120 180 240
3.95%
4.05%
4.15%
4.25%
4.35%
4.45%
4.55%
4.65%
4.75%
4.85%
4.95%
5.05%
5.15%
Properties
Property Details
Available Office Buildings in Baltimore
Location Code Property Type Sq Ft Asking In Budget?
M Windsor Avenue Retail/office space 5,000 $ 1,250,000 No
D Calvert Street Office space 2,000 $ 995,000 Yes
O Edison Highway Unfinished 13,000 $ 2,000,000 No
W Aliceanna Street Office space 7,500 $ 2,000,000 No
D Charles Street Office space 7,400 $ 1,150,000 Yes
D Northern Parkway Former school 10,500 $ 1,450,000 No
M Highland Avenue Office space 8,100 $ 1,050,000 Yes
D Lombard Street Residential/office 4,000 $ 1,300,000 No
W Bond Street Retail/office space 3,000 $ 1,250,000 No
Equipment Loan
Equipment Loan
Year: 2020
Loan Details Loan Summary
Loan amount $15,000.00 Scheduled payment $1,278.28
Annual interest rate 4.15% Scheduled number of payments 12
Loan period in years 1 Actual number of payments 12
Number of payments per year 12 Total early payments $1,100.00
Start date of loan 2/26/20 Total interest $316.23
Total paid ERROR:#VALUE!
Optional extra payments $100.00
Pmt No Payment Date Beg Balance Payment Amt Extra Payment Total Payment Principal Interest Ending Balance Cumulative Interest
1 2/26/20 $15,000.00 $1,278.28 $100.00 $1,378.28 $1,326.40 $51.88 $13,673.60 $51.88
2 3/26/20 $13,673.60 $1,278.28 $100.00 $1,378.28 $1,330.99 $47.29 $12,342.61 $99.16
3 4/26/20 $12,342.61 $1,278.28 $100.00 $1,378.28 $1,335.59 $42.68 $11,007.02 $141.85
4 5/26/20 $11,007.02 $1,278.28 $100.00 $1,378.28 $1,340.21 $38.07 $9,666.81 $179.91
5 6/26/20 $9,666.81 $1,278.28 $100.00 $1,378.28 $1,344.85 $33.43 $8,321.96 $213.34
6 7/26/20 $8,321.96 $1,278.28 $100.00 $1,378.28 $1,349.50 $28.78 $6,972.46 $242.12
7 8/26/20 $6,972.46 $1,278.28 $100.00 $1,378.28 $1,354.16 $24.11 $5,618.30 $266.24
8 9/26/20 $5,618.30 $1,278.28 $100.00 $1,378.28 $1,358.85 $19.43 $4,259.45 $285.67
9 10/26/20 $4,259.45 $1,278.28 $100.00 $1,378.28 $1,363.55 $14.73 $2,895.91 $300.40
10 11/26/20 $2,895.91 $1,278.28 $100.00 $1,378.28 $1,368.26 $10.02 $1,527.65 $310.41
11 12/26/20 $1,527.65 $1,278.28 $100.00 $1,378.28 $1,372.99 $5.28 $154.65 $315.70
12 1/26/21 $154.65 $1,278.28 $0.00 $154.65 $154.12 $0.53 $0.00 $316.23
Ending Balance and Cumulative Interest
Ending Balance 43887 43916 43947 43977 44008 44038 44069 44100 44130 44161 44191 44222 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX 0 Cumulative Interest 43887 43916 43947 43977 44008 44038 44069 44100 44130 44161 44191 44222 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX