1bhlkgllbglgbl
Running head: FINAL PROJECT 2
FINAL PROJECT 2
Final Project: Small Business Financial Plan
Name of Student
Name of Instructor
Date
Executive Summary
Here we have introduced a fictitious small business company named “XYZ Sports Company”. The company is new and sells products related to sports like- shoes, gloves, etc. here we have calculated the Pro Forma Financial Statements including – Balance Sheet, Income Statement and also the Cash flow statement. This can help the firm to identify the growth as well as risks related to the change in the firm (Easton, et.al., 2018). The ratio analysis also helps to figure out the financial position of the firm.
Pro Forma Income Statement
|
XYZ Sports Company |
||||||
|
Pro Forma Income Statement for the period ending December 31, 2021 |
|
Current Data of March 31, 2021 |
||||
|
Sales |
|
520000 |
|
Sales |
|
350000 |
|
Cost of Goods Sold: |
|
|
|
Cost of Goods Sold: |
|
|
|
Raw Materials |
170000 |
|
|
Raw Materials |
100000 |
|
|
Labor |
250000 |
|
|
Labor |
200000 |
|
|
Total Cost of Goods Sold |
|
420000 |
|
Total Cost of Goods Sold |
|
300000 |
|
Gross Profit |
|
100000 |
|
Gross Profit |
|
50000 |
|
Operating Expenses: |
|
|
|
Operating Expenses: |
|
|
|
Salaries |
40000 |
|
|
Salaries |
30000 |
|
|
Depreciation |
20000 |
|
|
Depreciation |
10000 |
|
|
Insurance |
12000 |
|
|
Insurance |
8000 |
|
|
Office Lease |
10000 |
|
|
Office Lease |
8000 |
|
|
Advertising |
4000 |
|
|
Advertising |
2000 |
|
|
Maintainance |
4000 |
|
|
Maintainance |
2000 |
|
|
Total Operating Expenses |
|
90000 |
|
Total Operating Expenses |
|
60000 |
|
Net Income |
|
10000 |
|
Net Income |
|
-10000 |
Pro Forma Balance Sheet
|
XYZ Sports Company |
||||
|
Pro Forma Balance Sheet for the period ending December 31, 2021 |
Current Data of March 31, 2021 |
|||
|
Assets |
|
|
Assets |
|
|
Current Assets |
|
|
Current Assets |
|
|
Cash |
40000 |
|
Cash |
10000 |
|
Accounts Receivable |
70000 |
|
Accounts Receivable |
40000 |
|
Inventory |
30000 |
|
Inventory |
10000 |
|
Total Current Assets |
140000 |
|
Total Current Assets |
60000 |
|
Fixed Assets |
|
|
Fixed Assets |
|
|
Machinery |
5000 |
|
Machinery |
2000 |
|
Equipment |
40000 |
|
Equipment |
22000 |
|
Total Fixed Assets |
45000 |
|
Total Fixed Assets |
24000 |
|
Total Assets |
185000 |
|
Total Assets |
84000 |
|
|
|
|
|
|
|
Liabilities |
|
|
Liabilities |
|
|
Current Liabilities |
|
|
Current Liabilities |
|
|
Account Payable |
30000 |
|
Account Payable |
10000 |
|
Long term Debt |
20000 |
|
Long term Debt |
8000 |
|
Total Current Liabilities |
50000 |
|
Total Current Liabilities |
18000 |
|
Long Term Liabilities |
|
|
Long Term Liabilities |
|
|
Loan Payment |
100000 |
|
Loan Payment |
50000 |
|
Total Long term Liabilities |
100000 |
|
Total Long term Liabilities |
50000 |
|
Total Liabilities |
150000 |
|
Total Liabilities |
68000 |
|
Stockholders' Equity |
|
|
Stockholders' Equity |
|
|
Capital |
25000 |
|
Capital |
12000 |
|
Retained Earnings |
10000 |
|
Retained Earnings |
4000 |
|
Total Stockholder's Equity |
35000 |
|
Total Stockholder's Equity |
16000 |
|
Total Liabilities and Stockholders'Equity |
185000 |
|
Total Liabilities and Stockholders'Equity |
84000 |
Pro Forma Cash Flow Statement
|
XYZ Sports Company |
||||
|
Pro Forma Cash Flow Statement for the period ending December 31, 2021 |
Current Data of March 31, 2021 |
|||
|
Cash Flow from Operataions |
|
|
Cash Flow from Operataions |
|
|
Payments |
500000 |
|
Payments |
310000 |
|
Material Purchase |
160000 |
|
Material Purchase |
100000 |
|
Payroll Costs |
210000 |
|
Payroll Costs |
150000 |
|
Other Payments |
88000 |
|
Other Payments |
50000 |
|
Total CashFlow From Operations |
42000 |
|
Total CashFlow From Operations |
10000 |
|
|
|
|
|
|
|
CashFlow from Investing |
|
|
CashFlow from Investing |
|
|
Equipment Purchase |
10000 |
|
Equipment Purchase |
6000 |
|
Total CashFlow from Investing |
10000 |
|
Total CashFlow from Investing |
6000 |
|
|
|
|
|
|
|
CashFlow from Financing |
|
|
CashFlow from Financing |
|
|
Loan Payments |
15000 |
|
Loan Payments |
8000 |
|
Total CashFlow from Financing |
15000 |
|
Total CashFlow from Financing |
8000 |
|
|
|
|
|
|
|
Net Change in Cash |
17000 |
|
Net Change in Cash |
-4000 |
|
Beginning Cash Balance |
23000 |
|
Beginning Cash Balance |
15000 |
|
Ending Cash Balance |
40000 |
|
Ending Cash Balance |
11000 |
Ratio Analysis
|
Profitability Ratios |
||
|
Debt Ratio |
Total liabilities/ Total shareholder's equity |
4.29 |
|
Debt-to-equity ratio |
Total liabilities/ Total assets |
0.81 |
|
Long term debt to equity ratio |
long term liabilities/ total equity |
2.86 |
|
Noncurrent assets to net worth |
non current assets/ equity |
1.29 |
|
Liquidity Ratios |
||
|
current ratio |
current assets/ current liabilities |
2.80 |
|
quick ratio |
Liquid assets/current liabilities |
0.80 |
|
Efficiency Ratios |
||
|
ROE |
net income/shareholders equity |
0.29 |
|
ROA |
net income/total assets |
0.05 |
|
ROCE |
EBIT/capital employed |
0.40 |
Discussion
As we can see from the above analysis, that the increase in the sales of the introducing some new factors improved the financial condition of the firm. The net income has increased and there is a positive impact. The projection for sales and also costs by the firm results in a positive net income. The cash balance also improved and also the loan payment is completed with a profit. The financial ratios show the financial position of the firm which is also very much impressive (Robinson, 2020). The firm can repay its debts and produces enough cash for transactional purposes.
References:
Easton, P. D., McAnally, M. L., Sommers, G. A., & Zhang, X. J. (2018). Financial statement analysis & valuation. Boston, MA: Cambridge Business Publishers.
Robinson, T. R. (2020). International financial statement analysis. John Wiley & Sons.