Your family business is expanding Based on your experience and in depth knowledge of the market, you have estimated the following results for the first 2 years (8 quarters) of the project Expected revenues for the first two years are as follows In addition, sales for the 1 st quarter of Year 3 are projected at $520,000 Year 1 (000s) Year 2 (000s) Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 40 72 128 160 224 280 352 440 General and administrative expenses (wages, taxes, office etc ) are estimated to be 15 of sales Sales salaries and commissions are estimated to be 10 of sales Accounts receivable at the beginning of this expansion are $0 Collection period 30 days Accounts payable at the beginning of the expansion are $0 The Company quarterly purchases from suppliers 60 of the next quarters forecasted sales Suppliers are paid on average in 60 days You will need to buy new equipment furniture in both Year 1 Q1 and Year 1 Q4 for $40,000 ($80,000 total in Year 1) To help start the expansion you have secured an initial cash loan from the bank of $80,000 Interest on this loan is $2,400 per quarter The company will pay back the full $80,000 in the Year 2 Q4 Interest on any additional short term borrowing is expected to be 3 per quarter The Company wishes to maintain an $80,000 minimum balance at all times to best manage its working capital and any unexpected commitments Question 1 (20 marks) Based on the information above build a Cash Budget for the expansion Use Appendix A From above, does the company require any short term financing Explain (50 100 words) If so, use the template in Appendix B to build a Short Term Financing Plan Appendix A Cash Budget Year 1 '000s) 2 03 01 Year 2000s 02 04 01 04 Cash Collections Beginning A R Sales Collection of accounts Ending A R Cash Disbursements Beginning A P Purchases Paid A P Ending A P Total Cash Outflows Paid A P General admin Expenses Sales salaries commissions Capital expenditures Loan Repayment Loan Interest Total cash disbursements Net Cash Flows Beginning cash balance Total cash collections Total cash disbursements Net cash inflow Ending cash balance Minimum cash balance Cumulative surplus (deficit) Foc

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 27, 2024

Your family business is expanding. Based on your experience and in depth knowledge of the market, you have estimated the following results for the first

Your family business is expanding. Based on your experience and in depth knowledge of the market, you have estimated the following results for the first 2 years (8 quarters) of the project.

Expected revenues for the first two years are as follows.
- In addition, sales for the 1^st quarter of Year 3 are projected at $520,000.

*Year 1 (000s)*				*Year 2 (000s)*
Q1	Q2	Q3	Q4	Q1	Q2	Q3	Q4
40	72	128	160	224	280	352	440

General and administrative expenses (wages, taxes, office etc.) are estimated to be 15% of sales.

Sales salaries and commissions are estimated to be 10% of sales.

Accounts receivable at the beginning of this expansion are $0.
- Collection period = 30 days

Accounts payable at the beginning of the expansion are $0.
- The Company quarterly purchases from suppliers = 60% of the next quarters forecasted sales.
- Suppliers are paid on average in 60 days.

You will need to buy new equipment & furniture in both Year 1 Q1 and Year 1- Q4 for $40,000 ($80,000 total in Year 1).

To help start the expansion you have secured an initial cash loan from the bank of $80,000. Interest on this loan is $2,400 per quarter. The company will pay back the full $80,000 in the Year 2 Q4.

Interest on any additional short-term borrowing is expected to be 3% per quarter.

The Company wishes to maintain an $80,000 minimum balance at all times to best manage its working capital and any unexpected commitments.

Question #1 (20 marks)

Based on the information above build a Cash Budget for the expansion. Use Appendix A
From above, does the company require any short-term financing? Explain. (50 100 words)
1. If so, use the template in Appendix B to build a Short-Term Financing Plan.

Appendix A-Cash Budget Year 1 ['000s) 2 03 01 Year 2000s! 02 04 01 04 Cash Collections Beginning A/R Sales Collection of accounts Ending A/R Cash Disbursements Beginning A/P Purchases Paid A/P Ending A/P Total Cash Outflows Paid A/P General & admin. Expenses Sales salaries & commissions Capital expenditures Loan Repayment Loan Interest Total cash disbursements Net Cash Flows Beginning cash balance Total cash collections Total cash disbursements Net cash inflow Ending cash balance Minimum cash balance Cumulative surplus (deficit) Foc