Blowboney Enterprises Generating Financial Projections
Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
Blowboney Enterprises Generating Financial Projections
Question Description
BlowBoney Enterprises is a local technology company. The business has been successful, and it plans to expand. Consequently, they are interested in generating financial projections for the next 3 years. Their current financial information is highlighted below, and it is also reproduced in the downloadable excel template.
Note that the current year balance sheet is not necessarily consistent with the assumptions used to make pro forma projections of the future. You shouldn’t change anything in the current year information to match the assumptions about the future; the current information is to be used as given.
Income Statement Current Sales $2,400,000 Cost of Sales $1,400,000 Gross Margin $1,000,000 SG&A Expense $200,000 Depreciation Expense $125,000 Interest Expense $37,500 Interest Earned $12,500 Profit Before Tax $650,000 Taxes $227,500 Net Income $422,500 Dividends $0 Retained Earnings $422,500
Balance Sheet Current Current Assets Cash $800,000 Accounts Receivable $640,000 Inventory $56,250 Marketable Securities $475,000 Fixed Assets Gross Fixed Assets $2,362,500 Accumulated Depreciation $750,000 Net Fixed Assets $1,612,500 Total Assets $3,583,750 Current Liabilities Accounts Payable $937,500 Other Current Liabilities $118,750 Long-Term Debt $765,000 Stock Holder’s Equity Common Stock $1,500,000 Accumulated Retained Earnings $262,500 Total Liabilities & Equity $3,583,750 The current year balance sheet is not necessarily consistent with the assumptions we use to make the pro forma projections into the future. Do not “correct” anything in the current year information; the current information is to be used as given.
Assume that the proportions of cost of sales, SGA expenses, accounts receivable, inventory, net fixed assets, accounts payable and other current liabilities remain the same proportion of sales for the next 3 years as they were in the current year. You may assume that the level of common stock is constant (not a proportion of sales). You may assume that depreciation expense is a constant proportion of gross fixed assets.
Assume that borrowing additional funds comes at an interest rate of 5.75% and that marketable securities earn 4.25% interest. Assume that the firm maintains a constant level of $800,000 cash. Assume the firm does not pay dividends. Taxes are expected to remain at 35%. Assume that in the projection years, the firm uses either debt or marketable securities, but the two accounts would never both have positive values in the same year. Assume the firm doesn’t carry forward debt or marketable securities principal from year to year. Instead, the firm refinances (or adjusts) these levels every year.
Prepare a preliminary pro forma projection for BlowBoney for the next 3 years. Assume that sales grow at 20% per year.
What is the level of long-term debt projected for BlowBoney at the end of the 3 years? What is the interest earned by BlowBoney at year 3?
Suppose creditors protest due to the high level of accounts payable. Further, your CFO points out that the level of accounts receivable aren’t optimal.
What are the current levels of accounts receivable and accounts payable as a percentage of sales?
If the firm cuts the level of accounts payable (beginning in the first projected year) to exactly 10% of sales, and the level of accounts receivable to exactly 15% of sales, what is the level of long-term debt, if any, at the end of year 3?
Suppose investors in the firm insist on being paid significant dividends. If the firm wishes to begin paying a dividend (60% of net income) next year (first projected year), and if the firm wishes to have accounts payable at exactly 10% of sales, and have accounts receivable at exactly 15% of sales, what is the maximum constant rate at which the firm can grow and not exceed a debt/equity ratio of 35% in year 3?
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow