Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the following assumptions to develop a five-year set of pro forma statements. Make any additional assumptions you need. a. The entrepreneur has $300,000 to

image text in transcribedimage text in transcribed

Use the following assumptions to develop a five-year set of pro forma statements. Make any additional assumptions you need. a. The entrepreneur has $300,000 to invest in the venture, will raise an additional $150,000 from family members in exchange for equity and will borrow $200,000 in the form of long-term debt. A total of $600,000 will be invested in fixed assets that can be depreciated on a straight-line basis over five years. The balance of initial investments will be held as cash. New capital investments are needed each year to maintain net fixed assets equal to 1.2 times expected sales in the subsequent year. b. Expected sales during the first year is $250,000. Sales is expected to double each year for the next two years, to increase by 50% in the fourth year, and to increase by 20% in the fifth and sixth years. c. Based on industry data, cost of goods sold is expected to be 25% of sales, selling expense is expected to be 12% of sales, and general and administrative expense is expected to be $100,000 plus 7% of sales. There are no other material operating expenses. The above figures exclude depreciation expenses. d. The interest rate on debt is expected to be 9%, and revenue from short-term investment of cash is expected to be negligible. e. The corporate tax rate is 35%. There is no tax loss carry forward. f. Typical experience in the industry for ventures that are growing rapidly is that accounts receivable equals 20% of ending sales; inventory is 15% of cost of goods sold; accounts payable is 8% of cost of goods sold; wages payable is 5% of cost of goods sold; and taxes payable is negligible. g. The venture needs to maintain a cash balance equal to the lesser of 20% of annual sales or $50,000. h. If additional financing is needed, the entrepreneur hopes to use long-term debt to the extent that profitability is sufficient to cover interest expense (so that the full tax advantage of debt financing is realized). Use the following assumptions to develop a five-year set of pro forma statements. Make any additional assumptions you need. a. The entrepreneur has $300,000 to invest in the venture, will raise an additional $150,000 from family members in exchange for equity and will borrow $200,000 in the form of long-term debt. A total of $600,000 will be invested in fixed assets that can be depreciated on a straight-line basis over five years. The balance of initial investments will be held as cash. New capital investments are needed each year to maintain net fixed assets equal to 1.2 times expected sales in the subsequent year. b. Expected sales during the first year is $250,000. Sales is expected to double each year for the next two years, to increase by 50% in the fourth year, and to increase by 20% in the fifth and sixth years. c. Based on industry data, cost of goods sold is expected to be 25% of sales, selling expense is expected to be 12% of sales, and general and administrative expense is expected to be $100,000 plus 7% of sales. There are no other material operating expenses. The above figures exclude depreciation expenses. d. The interest rate on debt is expected to be 9%, and revenue from short-term investment of cash is expected to be negligible. e. The corporate tax rate is 35%. There is no tax loss carry forward. f. Typical experience in the industry for ventures that are growing rapidly is that accounts receivable equals 20% of ending sales; inventory is 15% of cost of goods sold; accounts payable is 8% of cost of goods sold; wages payable is 5% of cost of goods sold; and taxes payable is negligible. g. The venture needs to maintain a cash balance equal to the lesser of 20% of annual sales or $50,000. h. If additional financing is needed, the entrepreneur hopes to use long-term debt to the extent that profitability is sufficient to cover interest expense (so that the full tax advantage of debt financing is realized)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Finance In Democratic Process Fiscal Institutions And Individual Choice

Authors: James M. Buchanan

1st Edition

0865972192, 978-0865972193

More Books

Students also viewed these Finance questions