Homework Help is Here – Start Your Trial Now!
Business
Finance
Mailings Review View Help Unless you need to edit, it's safer to stay in Protected View. Depreciation $ 159,000 Misc. Expenses $ 34,000 T Earnings before Taxes $380,680 Kimberly Cammon KC Enable Editing P/E Ratio Market price Number of shares outstanding $ 50.00 20.000 Comments

Mailings Review View Help Unless you need to edit, it's safer to stay in Protected View. Depreciation $ 159,000 Misc. Expenses $ 34,000 T Earnings before Taxes $380,680 Kimberly Cammon KC Enable Editing P/E Ratio Market price Number of shares outstanding $ 50.00 20.000 Comments

Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter27: Time Value Of Money (compound)
Section: Chapter Questions
Problem 2R
See similar textbooks
icon
Related questions
Question

Toby’s forecasted 2021 financial statements follow, along with some industry average ratios.  Calculate Toby’s 2021 forecasted ratios and fill in the above table.  Calculate the EPS and DPS.  The company has a 40% payout ratio.  

ysis - Protected View Saved to this PC Mailings Review Help ses. Unless you need to edit, it's safer to stay in Protected View. Depreciation $ 159,000 Misc. Expenses $ 34,000 % 5 • O Search Earnings before Taxes Taxes Net Income View Industry Financial Ratios Quick Ratio Current Ratio Inventory Turnover AR Period Fixed Asset Turnover Total Asset Turnover Return on Assets Return on Equity Total Debt Ratio G Profit Margin on Sales P/E Ratio 16 4- Y H N J+ & 7 U 8 hp 18 * $ 380,680 $ 126,306 $ 254,374 TAA M 19 2x 35 days 13x 2.6x 9.10% 20% 50% 5% 6x K 3x 8x ▷ll Enable Editing a f10 P/E Ratio Market price Number of shares outstanding Toby's Financial Ratios Quick Ratio Current Ratio Inventory Turnover Kimberly Cammon KC Days Sales Outstanding Fixed Asset Turnover Total Asset Turnover Return on Assets Return on Equity Total Debt Ratio Profit Margin on Sales P/E Ratio W X D Focus 112 S!!!! insert $ 50.00 Ratio prt sc 20,000 pause - Comments 69 backspace + 100% 12:02 AM 1/22/2023 delete home enter pg up T shift
Transcribed Image Text:ysis - Protected View Saved to this PC Mailings Review Help ses. Unless you need to edit, it's safer to stay in Protected View. Depreciation $ 159,000 Misc. Expenses $ 34,000 % 5 • O Search Earnings before Taxes Taxes Net Income View Industry Financial Ratios Quick Ratio Current Ratio Inventory Turnover AR Period Fixed Asset Turnover Total Asset Turnover Return on Assets Return on Equity Total Debt Ratio G Profit Margin on Sales P/E Ratio 16 4- Y H N J+ & 7 U 8 hp 18 * $ 380,680 $ 126,306 $ 254,374 TAA M 19 2x 35 days 13x 2.6x 9.10% 20% 50% 5% 6x K 3x 8x ▷ll Enable Editing a f10 P/E Ratio Market price Number of shares outstanding Toby's Financial Ratios Quick Ratio Current Ratio Inventory Turnover Kimberly Cammon KC Days Sales Outstanding Fixed Asset Turnover Total Asset Turnover Return on Assets Return on Equity Total Debt Ratio Profit Margin on Sales P/E Ratio W X D Focus 112 S!!!! insert $ 50.00 Ratio prt sc 20,000 pause - Comments 69 backspace + 100% 12:02 AM 1/22/2023 delete home enter pg up T shift
lysis Protected View Saved to this PC ✓ Mailings Review Help uses. Unless you need to edit, it's safer to stay in Protected View. % 5 O Search View Forecasted Balance Sheet for 2021 Cash Accounts receivables Inventories Total current assets Land and building Machinery Other fixed assets Total assets 1. Toby's forecasted 2021 financial statements follow, along with some industry average ratios. Calculate Toby's 2021 forecasted ratios and fill in the above table. Calculate the EPS and DPS. The company has a 40% payout ratio. 40 Forecasted Income Statement for 2021 $6,390,000 $5,580,000 $ 810,000 Sales Cost of goods sold Gross operating profit General admin & selling expenses Depreciation Misc. Expenses Earnings before Taxes Taxes Net Income Industry Financial Ratios Y 17 & ♫+ 18 * KAA $ 72,000 $ 639,000 $ 994,000 $1,705,000 $ 338,000 $ 132,000 $ 61,000 $2,236,000 8 $ 236,320 $ 159,000 $ 34,000 $ 380,680 $ 126,306 $ 254,374 fg DII Enable Editing 9 Accounts and notes payable Accruals Total current liabilities Per-Share Data EPS Long-term debt Common stock Retained earnings Total liabilities and equity DPS P/E Ratio Market price Number of shares outstanding f10 Toby's Financial Ratios W Kimberly Cammon DDI $11 X P D Focus 88 F (12 insert + ** $ KC Ratio $ 432,000 $ 170,000 $ 602,000 $ 604,290 $ 775,000 $ 254,710 $2,236,000 20,000 50.00 prt sc $ ] $ 7. Com backspace 1
Transcribed Image Text:lysis Protected View Saved to this PC ✓ Mailings Review Help uses. Unless you need to edit, it's safer to stay in Protected View. % 5 O Search View Forecasted Balance Sheet for 2021 Cash Accounts receivables Inventories Total current assets Land and building Machinery Other fixed assets Total assets 1. Toby's forecasted 2021 financial statements follow, along with some industry average ratios. Calculate Toby's 2021 forecasted ratios and fill in the above table. Calculate the EPS and DPS. The company has a 40% payout ratio. 40 Forecasted Income Statement for 2021 $6,390,000 $5,580,000 $ 810,000 Sales Cost of goods sold Gross operating profit General admin & selling expenses Depreciation Misc. Expenses Earnings before Taxes Taxes Net Income Industry Financial Ratios Y 17 & ♫+ 18 * KAA $ 72,000 $ 639,000 $ 994,000 $1,705,000 $ 338,000 $ 132,000 $ 61,000 $2,236,000 8 $ 236,320 $ 159,000 $ 34,000 $ 380,680 $ 126,306 $ 254,374 fg DII Enable Editing 9 Accounts and notes payable Accruals Total current liabilities Per-Share Data EPS Long-term debt Common stock Retained earnings Total liabilities and equity DPS P/E Ratio Market price Number of shares outstanding f10 Toby's Financial Ratios W Kimberly Cammon DDI $11 X P D Focus 88 F (12 insert + ** $ KC Ratio $ 432,000 $ 170,000 $ 602,000 $ 604,290 $ 775,000 $ 254,710 $2,236,000 20,000 50.00 prt sc $ ] $ 7. Com backspace 1
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
SEE MORE TEXTBOOKS