Education assistant

APPENDIX 1 - PART B

Financial Details

The tables on this appendix are not required to appear in your final paper but are offered as a guide to organize your data. Each group is required to prepare and present the following worksheets for the FY 2022:

· Revenue analysis

· Budget

· Cash flow projections

Table of Contents Financial Details 2 Introduction 2 Guidelines for financing and/or funding capital: 2 Revenue and Expenses 2 Academic Services 2 Rent and Utilities 2 Payroll and Benefit 3 Services 3 Student Services 3 Workshop Services 4 Professional Development Services 4

Financial Details

Introduction

Your company’s first day of business will be January 1st, 2022. Your company expects to realize revenue from services sold to school districts in your region/division after the first quarter (Q1) of the fiscal year (FY) starting January 1st, 2022 and ending December 31st, 2022. Financing and/or funding will be crucial to sustain the operations of your company, especially during Q1 FY 2022 (January-March), when revenue from services will not be available. Your company has secured the following sources of capital to meet its financial obligations:

Guidelines for financing and/or funding capital:

· Financing and/or funding capital cannot exceed 100% of projected revenues from sales during FY 2022.

· Financing and/or funding obtained must be disbursed at least twice during FY 2022.

· Loan repayments must begin two months after initial disbursement.

Type of Financing or Funding	Amount	Disbursement Schedule	Repayment Conditions	Annual Percentage Rate (APR)	Equity Sold (if any)	Other (add as needed)
Loans	$500,000	Covering salaries and wages	Repay principal plus interest every month ($44,583/ month)	7%
Investments	$500,000	Covering non-personnel expense	/	/	20%
[add as needed]

Revenue and Expenses Comment by Demian Garcia Scalici: budget for advertising sales force (expenses might vary depending on sales force structure) what impact will the sales force structure have on payroll expenses?

Academic Services

Academic Service	Revenue	Admin. Expenses	Payroll Expenses	Benefit Expenses	Curriculum Expenses	Other Expenses	Calendar
SAP	$1,155,000	$48,000	$577,500	/	/	/	August-June
LSS	$1,750,000	$70,000	$875,000	/	/	/	August-June
Teacher Workshop	$125,000	$5,000	$62,500	/	/	/	Year-round

Rent and Utilities

Expense	Amount / year
Rent Comment by Demian Garcia Scalici: Where is your office located? What is the cost for office space in your area?	$120,000
Utilities	$36000
Clean keeping	$12,000
Travel	$10,000
Repair and Maintenance	$10,000

Payroll and Benefits

Position	Academic Service or Department	Type (FT/PT)	Salary / year	Benefits / year (based on fringe Rate)
ASP	ASP	Full-Time	$400,000	$80,000
LSS	LSS	Full-Time	$300,000	$60,000
Teacher Workshop	Workshop	Full-Time	$50,000	$10,000

Services

Student Services

Academic Intervention Services

Revenue: $30,000-$90,000 per contract (depending on school district size). Typical contract length: 6 months.

Administrative Cost: [10-15% of revenue]

Payroll Cost: [30-50% of revenue]

Curriculum Cost: [10% of revenue]

Other Costs: [% of revenue]

Calendar: [August-June]

State Assessment Preparation

Revenue: $35,000-$55,000

Administrative Cost: 10% of revenue

Payroll Cost: 50% of revenue

Curriculum Cost: [none]

Other Costs:

Calendar: [August-June]

Long-term Substitute Staff

Revenue: $70,000 per contract.

Administrative Cost: 10% of revenue

Payroll Cost: 50% of revenue

Curriculum Cost: [none]

Other Costs:

Calendar: [August-June]

Homebound Instructional Services

Revenue: $35,000/500 hrs. 3-month contract.

Administrative Cost: 10% of revenue

Payroll Cost: 50% of revenue

Curriculum Cost: [none]

Other Costs:

Calendar: [August-June]

Student Behavioral Management

Revenue: $90,000 per contract.

Administrative Cost: 10% of revenue

Payroll Cost: 50% of revenue

Curriculum Cost: [none]

Other Costs:

Calendar: [August-June]

Workshop Services

Teacher Workshop

Revenue: $5,000 per workshop. 2-day workshop.

Administrative Cost: [10% of revenue]

Payroll Cost: [50 % of revenue]

Curriculum Cost: [none]

Other Costs: Transportation [% of revenue]

Calendar: [Year-round]

Parent Workshop

Revenue: $5,000 per workshop. 2-day workshop.

Administrative Cost: [10% of revenue]

Payroll Cost: [50 % of revenue]

Curriculum Cost: [none]

Other Costs: Transportation [% of revenue]

Calendar: [Year-round]

Professional Development Services

Professional Development Services

Revenue: $5,000 per workshop. 2-day workshop.

Administrative Cost: [10% of revenue]

Payroll Cost: [50 % of revenue]

Curriculum Cost: [none]

Other Costs: Transportation [% of revenue]

Calendar: [Year-round]

APPENDIX 1 - Part B - Financial Details Spring2021