Scribd
Upload
6 views8 pages

Excel

The document outlines the financial data analysis for Stuarts Bank, focusing on current and projected expenses for Caretaker Mobile Apps from 2022 to 2025. It includes a breakdown of expenses by category and quarter, as well as funding options with comparisons of different loan types. The data is presented in a structured format, highlighting key financial metrics and trends.

Uploaded by

jagnoormaan16
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
6 views8 pages

Excel

The document outlines the financial data analysis for Stuarts Bank, focusing on current and projected expenses for Caretaker Mobile Apps from 2022 to 2025. It includes a breakdown of expenses by category and quarter, as well as funding options with comparisons of different loan types. The data is presented in a structured format, highlighting key financial metrics and trends.

Uploaded by

jagnoormaan16
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 8

New Perspectives Excel 2019 | Module 4: SAM Project 1b

Stuarts Bank
ANALYZE AND CHART FINANCIAL DATA

Author: Jagnoor Singh

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.
a new copy of
Caretaker Mobile Apps
Current Expenses

Expense Quarter 1 Quarter 2 Quarter 3 Quarter 4


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

Expenses per Quarter


Training

Office

Marketing

Equipment

Employees

$- 0 00 0 00 0 00 0 00 0 00 0 00 0 00
0 0, 0 0, 0 0, 0 0, 0, 0, 0,
$2 $4 $6 $8 , 00 , 20 , 40
$1 $1 $1

Column B Column C Column D Column E


Trend
Quarter 1 Expenses

Training
15%

Employees
38%
Office
16%

Marketing
15%
Equipment
16%

0 00 0 00
0, 0, Quarter 4 Expenses
, 20 , 40
$1 $1

17%

38%
15%

15%
15%

Employees Equipment Marketing Office Training


ning
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

Projected Expenses 2022 - 2025

$3,500,000

$3,000,000

$2,500,000
Expenses per Category

$2,000,000

$1,500,000

$1,000,000

$500,000

$-
2022 2023 2024 2025

Employees Equipment Marketing Office Training Total


5

$3,580,000

$3,570,000

$3,560,000
Total Expenses

$3,550,000

$3,540,000

$3,530,000

$3,520,000

$3,510,000
2025

Training Total
Caretaker Mobile Apps
Funding Options

Number of years: 15
SBA Loan Bank Loan Investor
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)

Funding Options Comparison


($5,000.00) 1 2 3
Quarterly payment ($17,534.43) ($19,309.06) ($20,230.36)
($15,000.00)
Annual payment ($70,137.73) ($77,236.22) ($80,921.44)
($25,000.00)

($35,000.00)

($45,000.00)

($55,000.00)

($65,000.00)

($75,000.00)

($85,000.00)

Quarterly payment Annual payment

You might also like