Documentation
New Perspectives Excel 2019 | Module 4: SAM Project 1
Stuarts Bank
ANALYZE AND CHART FINANCIAL DATA
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.
Cu
ent Expenses
Caretaker Mobile Apps
Cu
ent Expenses
Expense Quarter 1 Quarter 2 Quarter 3 Quarter 4 Trend
Employees $ 320,850 $ 332,902 $ 337,675 $ 342,835
Equipment 140,350 135,675 137,450 135,965
Marketing 124,300 125,678 130,217 130,865
Office 134,910 135,120 135,775 135,242
Training 130,459 139,028 143,478 148,588
Total $ 850,869 $ 868,403 $ 884,595 $ 893,495
Chart Title
Employees Equipment Marketing Office Training 320850 140350 124300 134910 130459
Projected Expenses XXXXXXXXXX
Employees 2022 2023 2024 2025 1351340 1369902 1370675 1397835 Equipment 555860 557305 558450 560965 Marketing 523460 525608 530211 540865 Office 556968 556968 557250 557250 Training 546352 533018 523478 516588 Expense 2022 2023 2024 2025 2022 2023 2024 2025 Total 3533980 3542801 3540064 3573503 Axis Title
Projected Expenses
Caretaker Mobile Apps
Projected Expenses
Expense 2022 2023 2024 2025
Employees $ 1,351,340 $ 1,369,902 $ 1,370,675 $ 1,397,835
Equipment 555,860 557,305 558,450 560,965
Marketing 523,460 525,608 530,211 540,865
Office 556,968 556,968 557,250 557,250
Training 546,352 533,018 523,478 516,588
Total $ 3,533,980 $ 3,542,801 $ 3,540,064 $ 3,573,503
Funding
Caretaker Mobile Apps
Funding Options
Number of years: 15
SBA Loan Bank Loan Investo
Total loan amount $725,000 $725,000 $725,000
Annual interest rate 0.0525 0.0675 0.0750
Quarterly interest rate 0.0131 0.0169 0.0188
Total payments 60 60 60
Quarterly payment ($17,534.43) ($19,309.06) ($20,230.36)
Annual payment ($70,137.73) ($77,236.22) ($80,921.44)