Question

1) BIKE-WITH-US CORPORATION reported the following for 2018. Sales $325,000 Cost of goods $200,000 Operating Costs...

1) BIKE-WITH-US CORPORATION reported the following for 2018. Sales $325,000 Cost of goods $200,000 Operating Costs 85,000 Depreciation 10,000 Interest 5,000 Taxes 6,000 Net Income 15,000 The company forecasts the following for 2019: Sales: 10% increase YOY COGS: remain same % of sales G&A expenses: remain same % of sales Depreciation: fixed Interest expenses: fixed Tax rate: 25%

Build a 2019 income statement forecast with the info.

2) BIKE-WITH-US CORPORATION had a book value of $100,000 in 2018 and It paid out 3,000 dividend

a) What was its Retention rate?

b) Calculate its sustainable growth rate.

3) A venture has the following assumptions for 2019: Revenues increase from $9,00,000 to $10,000,000 Receivables are usually about 10% of revenues; Inventory historically equals 15% of revenues, Payables are usually 5% of revenues What’s its Additional Financing Need (AFN) for 2019?

Homework Answers

Answer #1

1) Income statement for 2019:

Sales (325000 + 10%) = 357500

Less COGS (200000 + 10%) = 220000

Less Operating cost (85000 + 10%) = 93500

Less Depriciation (fixed) = 10000

Less Interest (fixed) = 5000

Profit before tax. = 29000

Tax @ 25% (29000 * 25%) = 7250

Net profit. = 21750

2) Profit retained = Net profit - Dividend = 21750 - 3000 = 18750

a) Retention ratio = Profit retained / Book value = 18750 / 100000 = 0.1875 or 18.75%

b) Sustainable growth rate = Return on equity * retention ratio

Sustainable growth rate = (3000/100000) * 0.1875

Sustainable growth rate = 0.03 * 0.1875 = 0.0056 or 0.56%

3) Revenue = 10,00,000,

Receivable = 10,00,000 * 10% = 1,00,000 ,

Inventory = 10,00,000 * 15% = 1,50,000

Payables = 10,00,000 * 5% = 50,000

Additional financing needed = Recievables + Inventory - Payables = 100000 + 150000 - 50000

Additional financing nedeed = 200000

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
In 2018, Alpha Company had $48,000,000 in Sales/Revenues, $15,500,000 in Costs of Goods Sold (COGS), $3,600,000...
In 2018, Alpha Company had $48,000,000 in Sales/Revenues, $15,500,000 in Costs of Goods Sold (COGS), $3,600,000 in Sales, General, and Administrative (SG&A) expenses, $1,200,000 in Depreciation expenses, $550,000 in interest payment, and $4,125,000 in taxes. The firm also paid $1,900,000 in dividends to shareholders that year. By how much did Alpha Company's Retained Earnings increase in 2018? What was Alpha Company's gross income in 2008?
ABC Company has the following financial information for 2018: Total current assets: $2,200,000 Total current liabilities:...
ABC Company has the following financial information for 2018: Total current assets: $2,200,000 Total current liabilities: $1,200,000 Cash: $300,000 Inventory: $1,000,000 Accounts Receivable: $800,000 Accounts Payable: $500,000 Net sales is $10,000,000 Variable cost (VCR) is 30% of sales Cost of Goods Sold (COGS) at 40% of sales Average daily cash flow $27,000 Standard deviation of cash flow is $40,000 Its ROE is 25% Total earnings of $500,000, dividend payout of $150,000. Its cost of capital is 7% Line of credit...
Corporation X reported the following information for 2019: Sales revenue.................................................................$1,530 Cost of goods sold........................................................... 1,050 Operating...
Corporation X reported the following information for 2019: Sales revenue.................................................................$1,530 Cost of goods sold........................................................... 1,050 Operating expenses............................................................ 165 Foreign currency translation gain........................................ 120 Cash dividends received on securities owned by the corporation.....6 Preferred dividends paid to stockholders.............................. 25 Tax rate of 20% What is comprehensive Income for 2019?
The Del Rio Derrick Co. has the following statements from 2018: Income Statement Sales                          $650,000 -...
The Del Rio Derrick Co. has the following statements from 2018: Income Statement Sales                          $650,000 - COGS                      507,000 Gross Profits             $143,000 - Expenses                -   91,000 EBIT                           $ 52,000 -Interest                      $ 12,800 EBT                            $ 39,200 - Taxes                       $    9,408 EAT                            $   29,792 Balance Sheet                                                                         Current liabilities                 $80,000 Current Assets         $136,500                             L-T Debt                              $160,000 Fixed Assets              563,500                             Equity                                  460,000 Total Assets               700,000                               Total Liabilities                                                                                       & Equity                             $700,000 The firm expects that sales will...
Austin Grocers recently reported the following 2018 income statement (in millions of dollars): Sales $700 Operating...
Austin Grocers recently reported the following 2018 income statement (in millions of dollars): Sales $700 Operating costs including depreciation 500 EBIT $200 Interest 40 EBT $160 Taxes (40%) 64 Net income $96 Dividends $32 Addition to retained earnings $64 For the coming year, the company is forecasting a 35% increase in sales, and it expects that its year-end operating costs, including depreciation, will equal 75% of sales. Austin's tax rate, interest expense, and dividend payout ratio are all expected to...
Austin Grocers recently reported the following 2018 income statement (in millions of dollars): Sales $700 Operating...
Austin Grocers recently reported the following 2018 income statement (in millions of dollars): Sales $700 Operating costs including depreciation 500 EBIT $200 Interest 40 EBT $160 Taxes (40%) 64 Net income $96 Dividends $32 Addition to retained earnings $64 For the coming year, the company is forecasting a 20% increase in sales, and it expects that its year-end operating costs, including depreciation, will equal 60% of sales. Austin's tax rate, interest expense, and dividend payout ratio are all expected to...
UX Corporation sells a single product for $50. Its management estimates the following revenues and costs...
UX Corporation sells a single product for $50. Its management estimates the following revenues and costs for the year 2020: Net sales $525,000Selling expenses—variable $20,300 Direct materials 148,000Selling expenses—fixed 18,600 Direct labour 65,900Administrative expenses—variable 10,000 Manufacturing overhead—variable 18,300Administrative expenses—fixed 10,800 Manufacturing overhead—fixed 17,400 Assume the price remains at $50 per unit and variable costs remain the same per unit, but fixed costs increase by 20% annually. Calculate the percentage increase in unit sales required to achieve the same level of...
BeerBev, Inc., reported the following operating information for a recent year: Sales $5,440,000 Cost of goods...
BeerBev, Inc., reported the following operating information for a recent year: Sales $5,440,000 Cost of goods sold $1,360,000 Selling, general and administration 408,000 $1,768,000 Income from operations $ 3,672,000 In addition, assume that BeerBev sold 34,000 barrels of beer during the year. Assume that variable costs were 75% of the cost of goods sold and 50% of selling, general and administration expenses. Assume that the remaining costs are fixed. For the following year, assume that BeerBev expects pricing, variable costs...
UX Corporation sells a single product for $40. Its management estimates the following revenues and costs...
UX Corporation sells a single product for $40. Its management estimates the following revenues and costs for the year 2020: Net sales $388,000 Selling expenses—variable $21,100 Direct materials 85,400 Selling expenses—fixed 20,100 Direct labour 56,400 Administrative expenses—variable 9,400 Manufacturing overhead—variable 21,700 Administrative expenses—fixed 9,800 Manufacturing overhead—fixed 9,700 a)Assuming fixed costs and net sales are spread evenly throughout the year, determine YUX’s monthly break-even point in units and dollars b) Calculate the contribution margin ratio, the annual margin of safety ratio,...
For 2017, Company XYZ reported $9000 of sales, $6000 of operating cost other than depreciation, and...
For 2017, Company XYZ reported $9000 of sales, $6000 of operating cost other than depreciation, and $1500 of depreciation. The company has no amortization charges, it had $280 in interest expense, and its corporate tax rate was 35%. 2018 data are expected to remain unchanged except for one item, depreciation, which is expected to increase by $839. By how much will net income change as a result of the change in depreciation? Enter your answer as a number with 2...