Question
i would question 2 and 3. ihave to answer for question 1. thank you
Planning for Growth at S&S Air After Chris completed the ratio analysis for S&S Air (see Chap ter 3. Mark and Todd approached
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer2

EFN = (A/S) x (Δ Sales) - (L/S) x (Δ Sales) - (PM x FS x (1-d))

A / S: Assets that change given a change in sales , to be expressed in %

ΔSales: Change in sales between the last reporting period and the forecasted sales.

L / S: Liabilities that change given a change in sales , to be expressed in %

PM: Profit Margin on Sales; i.e. net income / sales.

FS: Forecasted Sales

d: dividend payout i.e. Dividends/Net Income

---------------

Total Assets = 18308920

Total Sales last year = 30499420

Total Current Liabilities last year = 2919000

Profit Margin : 5.04%

Net Profit 1537452
Sales 30499420
Net Profit Margin 5.04%

Profit Margin = 5.04%

Forecasted Sales:

Sales 30499420
Growth 12%
Next Year Sales 34159350

Forecasted Sales: 34159350

Dividend Payout Ratio:

Net Profit 1537452
Dividend 560000
Divident Pay Out 0.364

Dividend payout ratio = 36.4%

Change in sales = Forecasted sales - previous year sales

=34159350- 30499420

=3659930

A/S = 18308920/30499420= 60.03%

L/S = 2919000/30499420= 9.57%

-------------------

EFN = (A/S) x (Δ Sales) - (L/S) x (Δ Sales) - (PM x FS x (1-d))

= (0.6003*3659930) - (0.0957*3659930)-((0.0504*34159350*(1-0.364))

= 751843.21

As EFN value is a positive value, it means that the company couldn't finance its operating activities using its own funds and thus to suffice the same, the EFN of 751843.21 is needed.

Sales of a company can grow at the given rate only when the company goes for EFN of 751843.

Note - Rounded off to nearest value.

***As per HOMEWORKLIB POLICY we can solve one question or specified question. Please re-post the next question for the solution. Thank you!!

Add a comment
Know the answer?
Add Answer to:
i would question 2 and 3. ihave to answer for question 1. thank you Planning for...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • please answer number 3. question 1 and 2 have been answered Planning for Growth at S&S...

    please answer number 3. question 1 and 2 have been answered Planning for Growth at S&S Air After Chris completed the ratio analysis for S&S Air (see Chap ter 3. Mark and Todd approached him about planning for next year's sales. The company had historically used lime planning for investment needs. As a result, the company experienced some challenging times because of cash flow problems. The lack of planning resulted in missed sales, as well as periods when Mark and...

  • Planning for Growth at S&S Air After Chris completed the ratio analysis for S&S Air (see...

    Planning for Growth at S&S Air After Chris completed the ratio analysis for S&S Air (see Chap ter 3. Mark and Todd approached him about planning for next year's sales. The company had historically used lime planning for investment needs. As a result, the company experienced some challenging times because of cash flow problems. The lack of planning resulted in missed sales, as well as periods when Mark and Todd were unable to draw salaries. To this end, they would...

  • please, solve in excel with descriptions thank you! Planning for Growth at S&S Air After Chris...

    please, solve in excel with descriptions thank you! Planning for Growth at S&S Air After Chris completed the ratio analysis for S&S Air (see Chapter 3), Mark and Todd approached him about planning for next year's sales. The company had historically used little planning for investment needs. As a result, the company experienced some challenging times because of cash flow problems. The lack of planning resulted in missed sales, as well as periods when Mark and Todd were unable to...

  • 3. Calculate the internal growth rate and sustainable growth rate for S&S Air. What do these...

    3. Calculate the internal growth rate and sustainable growth rate for S&S Air. What do these numbers mean? 4. S&S Air is planning for a growth rate of 12 percent next year. Calculate the EFN for the company assuming the company is operating at full capacity (Hint: beside sales also assume that Costs of goods sold, Other expenses, all company assets and Accounts payable grow with 12%). Can the company's sales increase at this growth rate? S&S AIR, INC. 2012...

  • Using S&S Air financial statements for 2018 below, prepare proforma (forecast) for 2019 financial statements and...

    Using S&S Air financial statements for 2018 below, prepare proforma (forecast) for 2019 financial statements and calculate the External Financing Needed (EFN) for the company. S&S Air, Inc 2018 Income Statement Sales $46,298.115 Cost of goods sold 34,536,913 Other expenses 5,870.865 Depreciation 2074.853 $ 3.815.484 EBIT Interest 725.098 S 3,090.386 Taxable income 772 597 Taxes (21%) $ 2.317.799 Net income s 705,000 Dividends Add to retained earnings 1.612.789 S&S Air. Inc 2018 Balance Sheet Liabilities and Equity Assets Current assets...

  • I need number 1 & 2. 90 PART 2 Financial Statements and Long Term Francial Planning...

    I need number 1 & 2. 90 PART 2 Financial Statements and Long Term Francial Planning own and fly their own airplanes. The company has two models the Birdie, which sells for $103.000, and the Eagle, which sells for $178,000 Although the company manufactures aircraft, its operations are different from commercial aircraft companies. S&S Air builds aircraft to order. By using prefabricated parts, the com pany can complete the manufacture of an airplane in only five weeks. The company also...

  • Long-term Financial Planning In-class Exercise The most recent financial statements for 7 Seas, I...

    Long-term Financial Planning In-class Exercise The most recent financial statements for 7 Seas, Inc. are shown here Income Statement Balance Sheet Sales Costs Taxable income Taxes (35%) Net income $4,600 Current assets $6,084 Current liabilities S1,244 3840 Fixed assets 5,183 Long-term debt 2,487 Equity 760 266 Total $494 $11,267 Total 11,267 Assets, costs, and current liabilities are proportional to sales. Long-term debt and equity are not. The company maintains a constant 50 percent dividend payout ratio. Like every other firm...

  • I have used the suggested formulas I have found for this problem but the answers keep...

    I have used the suggested formulas I have found for this problem but the answers keep coming out wrong. Please help! The Optical Scam Company has forecast a sales growth rate of 20 percent for next year. Current assets, fixed assets, and short-term debt are proportional to sales. The current financial statements are shown here:    INCOME STATEMENT Sales $ 32,200,000 Costs 27,743,800 Taxable income $ 4,456,200 Taxes 1,559,670 Net income $ 2,896,530 Dividends $ 1,158,612 Addition to retained earnings...

  • 1. Use this information for New Tech Company to answer the following question. You may (or...

    1. Use this information for New Tech Company to answer the following question. You may (or may not) need to fill in missing information.             NEW TECH COMPANY Income Statement 2010 2011 2012 Sales 100 110 120 Cost of goods sold 50 51 52 Depreciation 20 20 20 General, sales & admin expenses 70 65 60 Taxes 10 10 10 Net Income Balance Sheet 2010 2011 2012 Current Assets 40 45 40 Property, plant & equipment 60 55 60 Total...

  • 1. Compute the external financing needed to support the projected annual sales growth. The most recent...

    1. Compute the external financing needed to support the projected annual sales growth. The most recent financial statements for Fleury, Inc., follow. Sales for 2012 are projected to grow by 20%. Interest expense will remain constant. The tax rate and the dividend payout rate will remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. If the firm is operating at full capacity and no new debt or equity is issued, what external financing...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT