1 2 3 4 5 69 7 NOTE: You will use a combination of Proforma, Ratios,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1 2 3 4 5 69 7 NOTE: You will use a combination of Proforma, Ratios, and the Percent-of-Sales methods to create your forecasted financials. The Sharks gave you the $1,000,000 in funding you requested in exchange for 25% ownership of your company's profits. All the following are complete by March 31, 20X3: 1) your shark funding has been received, 2) new capital investments have been purchased and set up, and 3) additional labor has been hired and trained. SELLING & ADMINISTRATIVE EXPENSE: Use a 3-year average Percent-of-Sales to forecast S&A expenses. |(HINT: Find what percent S&A expense is for each of 20X0, 20X1, and 20X2, and average the 3 results together. Use the resulting average S&A Percent-of-Sales to forecast S&A into the future.) RENT EXPENSE: Rent expense is a fixed cost in the amount of $15,000 per year in 20X0-20X2, increasing to $200,000 per year in 20X3. DEPRECIATION EXPENSE: Depreciation expense is a fixed cost in the amount of 10% of Plant & Equipment each year. INTEREST EXPENSE: This is a Fixed cost, and is 10% of Long-term Liabilities. TAXES: Because you live in a business-friendly State (Florida), you don't have to pay state taxes on your LLC's income. You do, however, still have to pay Federal taxes. Also, in 20X2, higher tax rates were passed for the 20X3 tax year, pushing income over $400,000 into the 39.6% tax bracket. Because of this, use 36% as your effective tax rate. (NOTE: If the taxes shown for 20X0-20X2 seem high, it's because you had income from another job that threw your LLC income into a slightly higher tax bracket. However, you'll quit that job IF the Sharks fund you!) SHARES: Issued 26,000 $1-par shares to the sharks for a 25% ownership stake. MARKETABLE SECURITIES: Plan to keep Marketable Securities at 60% of Cash levels. 9 CASH: Increases to $50,000 in 20X3 and stays at that level. 8 *2 10 11 ACCOUNTS RECEIVABLE: Use a 3-year average Receivables Turnover ratio to forecast. INVENTORY: Compute a 3-year average of inventory as a Percent-of-Sales, and then use that figure to forecast inventory levels through 20X7. 12 13 14 15 16 17 18 19 20 20 PLANT & EQUIPMENT: There is a new capital expenditure of $750,000 dollars in 20X3, paid for from the $1M in funding from the Sharks, rather than with new debt. (All capital expenditures are assumed to occur on January 1st of the year of purchase, and no equipment is sold or salvaged during the forecasted period.) ACCUMULATED DEPRECIATION: Each year, 10% of the total amount of Plant and Equipment is added to the depreciation amount. ACCOUNTS PAYABLE: Use the 3-year average Current Ratio to forecast. (HINT: The Current Ratio will help you forecast TOTAL Current Liabilities, not Accounts Payable. Find Total Current Liabilities and Accrued Expenses first, and then you can solve for Accounts Payable.) ACCRUED EXPENSES: Use the 3-year average Percent-of-Sales method to forecast. LONG-TERM LIABILITIES: Pay down $100,000 of old debt every year starting in 20X3. COMMON STOCK ($1 Par): Increase by the dollar value of shares issued to Sharks (26,000 shares at $1 par). CAPITAL PAID IN EXCESS OF PAR: The Shark's full investment of $1M must be reflected on the Balance Sheet. The stock received by the Shark, worth $26,000 (at Par value of $1 per share), is already reflected under Common Stock. The rest of the shark's investment value is added to this account. RETAINED EARNINGS: This amount is whatever it takes to make the Balance Sheet balance! (HINT: Remember Total Liabilities + Stockholder's Equity is equal to Total Assets. Once Total L + SE is determined, Total SE can be solved. Finally, once Total SE is solved, Retained Earnings can be solved.) 21 DIVIDENDS: You do not pay dividends now and do not plan to while in a growth stage. 1 2 3 4 5 69 7 NOTE: You will use a combination of Proforma, Ratios, and the Percent-of-Sales methods to create your forecasted financials. The Sharks gave you the $1,000,000 in funding you requested in exchange for 25% ownership of your company's profits. All the following are complete by March 31, 20X3: 1) your shark funding has been received, 2) new capital investments have been purchased and set up, and 3) additional labor has been hired and trained. SELLING & ADMINISTRATIVE EXPENSE: Use a 3-year average Percent-of-Sales to forecast S&A expenses. |(HINT: Find what percent S&A expense is for each of 20X0, 20X1, and 20X2, and average the 3 results together. Use the resulting average S&A Percent-of-Sales to forecast S&A into the future.) RENT EXPENSE: Rent expense is a fixed cost in the amount of $15,000 per year in 20X0-20X2, increasing to $200,000 per year in 20X3. DEPRECIATION EXPENSE: Depreciation expense is a fixed cost in the amount of 10% of Plant & Equipment each year. INTEREST EXPENSE: This is a Fixed cost, and is 10% of Long-term Liabilities. TAXES: Because you live in a business-friendly State (Florida), you don't have to pay state taxes on your LLC's income. You do, however, still have to pay Federal taxes. Also, in 20X2, higher tax rates were passed for the 20X3 tax year, pushing income over $400,000 into the 39.6% tax bracket. Because of this, use 36% as your effective tax rate. (NOTE: If the taxes shown for 20X0-20X2 seem high, it's because you had income from another job that threw your LLC income into a slightly higher tax bracket. However, you'll quit that job IF the Sharks fund you!) SHARES: Issued 26,000 $1-par shares to the sharks for a 25% ownership stake. MARKETABLE SECURITIES: Plan to keep Marketable Securities at 60% of Cash levels. 9 CASH: Increases to $50,000 in 20X3 and stays at that level. 8 *2 10 11 ACCOUNTS RECEIVABLE: Use a 3-year average Receivables Turnover ratio to forecast. INVENTORY: Compute a 3-year average of inventory as a Percent-of-Sales, and then use that figure to forecast inventory levels through 20X7. 12 13 14 15 16 17 18 19 20 20 PLANT & EQUIPMENT: There is a new capital expenditure of $750,000 dollars in 20X3, paid for from the $1M in funding from the Sharks, rather than with new debt. (All capital expenditures are assumed to occur on January 1st of the year of purchase, and no equipment is sold or salvaged during the forecasted period.) ACCUMULATED DEPRECIATION: Each year, 10% of the total amount of Plant and Equipment is added to the depreciation amount. ACCOUNTS PAYABLE: Use the 3-year average Current Ratio to forecast. (HINT: The Current Ratio will help you forecast TOTAL Current Liabilities, not Accounts Payable. Find Total Current Liabilities and Accrued Expenses first, and then you can solve for Accounts Payable.) ACCRUED EXPENSES: Use the 3-year average Percent-of-Sales method to forecast. LONG-TERM LIABILITIES: Pay down $100,000 of old debt every year starting in 20X3. COMMON STOCK ($1 Par): Increase by the dollar value of shares issued to Sharks (26,000 shares at $1 par). CAPITAL PAID IN EXCESS OF PAR: The Shark's full investment of $1M must be reflected on the Balance Sheet. The stock received by the Shark, worth $26,000 (at Par value of $1 per share), is already reflected under Common Stock. The rest of the shark's investment value is added to this account. RETAINED EARNINGS: This amount is whatever it takes to make the Balance Sheet balance! (HINT: Remember Total Liabilities + Stockholder's Equity is equal to Total Assets. Once Total L + SE is determined, Total SE can be solved. Finally, once Total SE is solved, Retained Earnings can be solved.) 21 DIVIDENDS: You do not pay dividends now and do not plan to while in a growth stage.
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Which of the following statements is correct regarding a work sheet and the adjustment process? Adjusting journal entries are prepared from the Adjusted Trial Balance columns. Adjusting journal...
-
Discuss the three cultural change strategies a foreign marketer can pursue.
-
Refer to the data on the growth of female salmon in the marine environment in Table D.7 of the Data Bank. A computer calculation gives a 95% confidence interval. (a) Does the 95% confidence interval...
-
Using the information for the Melville Corporation above, calculate the cash flow from financing activities. Use the following information regarding the Melville Corporation Accounts payable...
-
Yemi Ltd. is a retailer operating in Edmonton, Alberta. Yemi uses the perpetual inventory method. All sales returns from customers result in the goods being returned to inventory; the inventory is...
-
You are analyzing the after-tax cost of debt for a firm. You know that the firm's 12-year maturity, 11.50 percent semiannual coupon bonds are selling at a price of $1,223. Assuming that these bonds...
-
Human Resource Consulting (HRC) surveyed a random sample of 78 Twin Cities construction companies to find information on the costs of their health care plans. One of the items being tracked is the...
-
Explain why there may be a difference between the dividend payable and its yield.
-
When auditing prepaid insurance, an auditor discovers that the original insurance policy on plant equipment is not available for inspection. The policy's absence most likely indicates the possibility...
-
Write down in you notebook what is meant by (a) an account having a debit balance (b) an account having a credit balance.
-
Which two investment ratios take market prices into account?
-
What two indicators are used to classify performance measures?
-
Ben and Jerry are partners in a CPA firm (Ben & Jerry's, LLP). They depreciate the building and equipment over 39 and 7 years, respectively. Please prepare their partnership return for 2019 from...
-
Wholesalers Ltd. deals in the sale of foodstuffs to retailers. Owing to economic depression, the firm intends to relax its credit policy to boost productivity and sales. The firms current credit...
-
Consider a publicly-held company whose products you are familiar with. Some examples might include: Access the companys public website and search for its most recent annual report. (Note: Some...
-
The 2014 financial statements of LVMH Moet Hennessey-Louis Vuitton S.A. are presented in Appendix C of this book. LVMH is a Paris-based holding company and one of the worlds largest and best-known...
-
San Francisco Sea Salt's controller prepared the following statements of cash flow (in thousands of dollars) for the past two years, the current year (2020), and the upcoming year (2021): After...
Study smarter with the SolutionInn App