zahara
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 2022 - 2025 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)