Documentation New Perspectives Excel 2019 | Module 4: SAM Project 1b Stuarts Bank ANALYZE AND CHART FINANCIAL DATA Author:FATEMATUZ ZAHARA Note: Do not edit this sheet. If your name does not appear...

1 answer below »
Documentation
New Perspectives Excel 2019 | Module 4: SAM Project 1b
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.
Current Expenses
Caretaker Mobile Apps
Current Expenses
ExpenseQuarter 1Quarter 2Quarter 3Quarter 4Trend
Employees$ 320,850$ 332,902$ 337,675$ 342,835
Equipment140,350135,675137,450135,965
Marketing124,300125,678130,217130,865
Office134,910135,120135,775135,242
Training130,459139,028143,478148,588
Total$ 850,869$ 868,403$ 884,595$ 893,495
Chart Title
EmployeesEquipmentMarketingOfficeTraining320850140350124300134910130459
Projected Expenses XXXXXXXXXX
Employees20222023202420251351340136990213706751397835Equipment555860557305558450560965Marketing523460525608530211540865Office556968556968557250557250Training546352533018523478516588Expense20222023202420252022202320242025Total3533980354280135400643573503Axis Title
Projected Expenses
Caretaker Mobile Apps
Projected Expenses
Expense2022202320242025
Employees$ 1,351,340$ 1,369,902$ 1,370,675$ 1,397,835
Equipment555,860557,305558,450560,965
Marketing523,460525,608530,211540,865
Office556,968556,968557,250557,250
Training546,352533,018523,478516,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 LoanBank LoanInvestor
Total loan amount$725,000$725,000$725,000
Annual interest rate0.05250.06750.0750
Quarterly interest rate0.01310.01690.0188
Total payments606060
Quarterly payment($17,534.43)($19,309.06)($20,230.36)
Annual payment($70,137.73)($77,236.22)($80,921.44)
Answered 1 days AfterMay 01, 2021

Solution

Akshay Kumar Garg answered on May 03 2021
22 Votes

Documentation
New Perspectives Excel 2019 | Module 4: SAM Project 1b
Stuarts Bank
ANALYZE AND CHART FINANCIAL DATA
Author:FATEMATUZ ZAHARA
Note: Do not edit this sheet. If...

Submit New Assignment

Copy and Paste Your Assignment Here