Question

Ch 16: Assignment - Financial Planning and Forecasting 3. Excess capacity adjustments Newtown Propane had sales of $1,820,000
0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

TURNOVER RATIOS ARE ROUNDED TO 4 DECIMALS. NEED ANY CHANGE, LET ME KNOW

BOND- Microsoft Excel (Product Activation Failed) Formulas File Home Insert Page Layout Data Review View Add-Ins E AutoSum -

Add a comment
Know the answer?
Add Answer to:
Ch 16: Assignment - Financial Planning and Forecasting 3. Excess capacity adjustments Newtown Propane had sales...
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
  • 5. Excess capacity adjustments Monk Consortium Corp. (Monk-Con) had sales of $1,720,000 last year on fixed...

    5. Excess capacity adjustments Monk Consortium Corp. (Monk-Con) had sales of $1,720,000 last year on fixed assets of $395,000. Given that Monk-Con's fixed assets were being used at only 96% of capacity, then the firm's fixed asset turnover ratio was . (Note: Round your answer to two decimal places.) How much sales could Monk Consortium Corp. (Monk-Con) have supported with its current level of fixed assets? O $1,612,500 o $2,060,417 o $1,702,084 o $1,791,667 When you consider that Monk-Con's fixed...

  • Osato Chemicals Inc. had sales of $1,550,000 last year on fixed assets of $345,000. Given that...

    Osato Chemicals Inc. had sales of $1,550,000 last year on fixed assets of $345,000. Given that Osato's fixed assets were being used at only 96% of capacity, then the firm's fixed asset turnover ratio was . (Note: Round your answer to two decimal places.) How much sales could Osato Chemicals Inc. have supported with its current level of fixed assets? $1,372,396 $1,291,666 $1,614,583 $1,776,041 When you consider that Osato's fixed assets were being underused, what should be the firm's target...

  • 4. Excess capacity adjustments Monk Consortium Corp. (Monk-Con) currently has $540,000 in total assets and sales...

    4. Excess capacity adjustments Monk Consortium Corp. (Monk-Con) currently has $540,000 in total assets and sales of $1,400,000. Half of Monk-Con's total assets come from net fixed assets, and the rest are current assets. The firm expects sales to grow by 22% in the next year. According to the AFN equation, the amount of additional assets required to support this level of sales is Monk-Con was using its fixed assets at only 96% of capacity last year. How much sales...

  • 3. Excess capacity adjustments Monk Consortium Corp. (Monk-Con) currently has $610,000 in total assets and sales...

    3. Excess capacity adjustments Monk Consortium Corp. (Monk-Con) currently has $610,000 in total assets and sales of $1,550,000. Half of Monk-Con's total assets come from net fixed assets, and the rest are current assets. The firm expects sales to grow by 18% in the next year. According to the AFN equation, the amount of additional assets required to support this level of sales is $ Monk-Con was using its fixed assets at only 93% of capacity last year. How much...

  • 3. Excess capacity adjustments Western Gas & Electric Co. (WG&E) currently has $540,000 in total assets and sal...

    3. Excess capacity adjustments Western Gas & Electric Co. (WG&E) currently has $540,000 in total assets and sales of $1,550,000. Half of WG&E's total assets come from net fixed assets, and the rest are current assets. The firm expects sales to grow by 19% in the next year. According to the AFN equation, the amount of additional assets required to support this level of sales is $ WG&E was using its fixed assets at only 95% of capacity last year....

  • Ch 16: Assignment - Financial Planning and Forecasting Attempts: Keep the Highest: 12 5. Using regression...

    Ch 16: Assignment - Financial Planning and Forecasting Attempts: Keep the Highest: 12 5. Using regression analysis to forecast assets The APN equation and the financial statement-forecasting approach both assume that assets grow at relatively the same rate as sales. However, the relationship between assets and sales is often a little more difficult than that. In particular, some firms use regression analysis to predict the required assets needed to support a given level of sales. U.S. Robotics Inc. has used...

  • Monk Consortium Corp. (Monk-Con) currently has $645,000 in total assets and sales of $1,550,000. Half of...

    Monk Consortium Corp. (Monk-Con) currently has $645,000 in total assets and sales of $1,550,000. Half of Monk-Con's total assets come from net fixed assets, and the rest are current assets. The firm expects sales to grow by 22% in the next year. According to the AFN equation, the amount of additional assets required to support this level of sales is $ Monk-Con was using its fixed assets at only 93% of capacity last year. How much sales could the firm...

  • 5. Using regression analysis to forecast assets The AFN equation and the financial statement–forecasting approach both...

    5. Using regression analysis to forecast assets The AFN equation and the financial statement–forecasting approach both assume that assets grow at relatively the same rate as sales. However, the relationship between assets and sales is often a little more difficult than that. In particular, some firms use regression analysis to predict the required assets needed to support a given level of sales. Mile Brewing Co. has used its historical sales and asset data to estimate the following regression equations: Accounts...

  • EXCESS CAPACITY Krogh Lumber's 2016 financial statements are shown here. Krogh Lumber: Balance Sheet as of...

    EXCESS CAPACITY Krogh Lumber's 2016 financial statements are shown here. Krogh Lumber: Balance Sheet as of December 31, 2016 (Thousands of Dollars) Cash $1,800 Accounts payable $7,200 Receivables 10,800 Notes payable 3,472 Inventories 12,600 Accrued liabilities 2,520 Total current assets $25,200 Total current liabilities $13,192 Mortgage bonds 5,000 Net fixed assets 21,600 Common stock 2,000 Retained earnings 26,608 Total assets $46,800 Total liabilities and equity $46,800 Krogh Lumber: Income Statement for December 31, 2016 (Thousands of Dollars) Sales $36,000 Operating...

  • Problem 1: Financial Statement Ratio Analysis (40 points total) Use the following financial statements for Dell,...

    Problem 1: Financial Statement Ratio Analysis (40 points total) Use the following financial statements for Dell, Inc. to answer the questions which follow: BALANCE SHEET (SMil) 2017 10,298 2018 7,972 % 28.9 2019 9,092 % 34.3 40.2 Cash & Short Term Investments Accounts Receivable Inventory Other Current Assets Total Current Assets Net Fixed Assets Intangibles Other Long Term Assets Total Assets 6,152 24.0 660 2.6 2,829 11.3 19.939 76.6 2,409 8.7 0 0 3,287 14.7 25,635 100.0 7,693 27.9 1,180...

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