4E1489101112131415161718192021File Home Insert Page LayoutX56 Assumption(s)7222324252627AutoSave Off HPasteClipboardACalibri✓: X✓ fx>BIU HSales RevenueLess: Cost of goods soldGross profitsLess: Operating expensesOperating profitsLess: Interest expenseNet profits before taxesLess: TaxesNet profits after taxes32°CMostly sunnyA A✓12~A~FontVReady Accessibility: Investigateī FIRSTNAME_LASTNAME_Accounting-Finance MBA Assignm.... Saved to this PC ✓Formulas Data Review View AutomateSales are expected to rise from the 2018 level ofThe interest expense in 2019 is expected to drop toThe firm plans to increase its cash dividend payments during 2019 toTax RateVRadical Designs Inc.Income StatementFor the year ended December 31, 2018Statement of Cash Flows■■= =====BCHIRadical Designs Inc. hopes to create a proforma income statement with select information gathered. Used the percent-of-sales method to prepare a 2019 pro formaincome statement.Q Search$$$$$$$$Financial RatiosAlignmentap40%3,500,0001,925,0001,575,000.00420,0001,155,000400,000755,000302,000453,000HelpGeneral$%90000000-%E3,500,000 to $ 3,900,000325,000320,000NumberFG5Horizontal Analysis Vertical AnalysisConditional Format as CellFormatting Table StylesStylesSearch99+Proforma-Balance SheetalKInsert Vx DeleteFormatCellsmyhpLΣ↓NProforma -Income StateAYSort & Find &Filter SelectEditing0deslyn douglas DD899PShow hidden iconsDmQLBJ ECommentsAnalyze Add-insDataAnalysisENGINTL00R00Add-insSShare ✔TUA+ 70%11:15 am15/10/2023 232425262728293031E14373839404142434445464748File HomeX495051PasteAutoSave Off HClipboardA<Insert Page LayoutCalibriLess. Interest expenseNet profits before taxesLess: TaxesNet profits after taxesLess: Cash dividendsTo retained earnings>BIU U HX✓ fx...Sales RevenueLess: Cost of goods soldGross profitsLess: Operating expensesOperating profitsLess: Interest expenseNet profits before taxesLess: TaxesNet profits after taxesLess: Cash dividendsTo retained earnings32°CMostly sunny32 Excel solution method: create proforma income statement33343536✓12FontBReady Accessibility: InvestigateVī FIRSTNAME_LASTNAME_Accounting-Finance MBA Assignm.... Saved to this PC ✓Formulas Data Review View AutomateStatement of Cash Flows■VRadical Designs Inc.Income StatementFor the year ended December 31, 2018A A~A~= == = = = 三AlignmentQ Search$$Cap圍400,000755,000302,000453,000250,000203,000nHelpGeneral$%90000000ENumberFGFinancial Ratios Horizontal Analysis Vertical Analysis5Conditional Format as CellFormatting Table StylesStylesHI99+SearchProforma-Balance SheetaJKInsert Vx DeleteFormatCellsmyhpLMΣ↓NAYSort & Find &Filter SelectEditing0Proforma -Income Statementdeslyn douglas DDPBDmQAnalyzeDataAnalysisECommentsENGINTLR0000Add-insAdd-insSShare ✔TUA+ 70%11:15 am15/10/2023

Income statement is the financial statement prepared by the entity for the purpose of determining…

Radical Designs Inc. hopes to create a proforma income statement with select information gathered. Used the percent-of-sales method to prepare a 2019 pro forma income statement. Assumption(s) Sales are expected to rise from the 2018 level of The interest expense in 2019 is expected to drop to The firm plans to increase its cash dividend payments during 2019 to Tax Rate Sales Revenue Less: Cost of goods sold Gross profits Less: Operating expenses Operating profits Less: Interest expense Net profits before taxes Less: Taxes Net profits after taxes Radical Designs Inc. Income Statement For the year ended December 31, 2018 S S $ $ $ S nl $ $ 3,500,000 to $3,900,000 325,000 320,000 40% 3,500,000 1,925,000 1,575,000.00 420,000 1,155,000 400,000 755,000 302,000 453,000

Radical Designs Inc. hopes to create a proforma income statement with select information gathered. Used the percent-of-sales method to prepare a 2019 pro forma income statement. Assumption(s) Sales are expected to rise from the 2018 level of The interest expense in 2019 is expected to drop to The firm plans to increase its cash dividend payments during 2019 to Tax Rate Sales Revenue Less: Cost of goods sold Gross profits Less: Operating expenses Operating profits Less: Interest expense Net profits before taxes Less: Taxes Net profits after taxes Radical Designs Inc. Income Statement For the year ended December 31, 2018 S S $ $ $ S nl $ $ 3,500,000 to $3,900,000 325,000 320,000 40% 3,500,000 1,925,000 1,575,000.00 420,000 1,155,000 400,000 755,000 302,000 453,000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Suppose a company has had the historic sales figures shown below. What would be the forecast for next years sales using the average approach?
Give answer with explanation
Use the "percent of sales method" of preparing pro forma financial statements to determine the projection for next year's accounts receivable. Make the following assumptions: current year's sales are $55,750,000; current year's cost of goods sold is $25,350,000; sales are expected to rise by 25%, The firm's investment in accounts receivable in the current year is $12,600,000. The firm's marginal tax rate is 35%. What is the projection for next year's accounts receivable? $10,320,000 $11,345,000 O $15,750,000 $8,772,000
A. Wally asks you to create an Income Statement for 2020 using the information below. 1. 2020 sales were 150% of last year’s sales2. Gross profit margin was 55%3. Operating profit margins were 15% 4. Interest expense fell to 7%, given a change in interest rates 5. The tax rate was 30% B. Based on the change in Income between 2020 and 2019, how would you say AndrewCo is doing?
A Comparison of Firm Performance 1 2 2013 Financials 3 Net operating revenues 4 Cost of goods sold 5 Gross profit 6 Selling, general, and administrative expense 7 Other costs 8 Operating income 9 Interest expense 10 Other income (loss) - net 11 Income before income taxes 12 Income taxes 13 Net income 14 Assets 15 Cash and cash equivalents 16 Net receivables 17 Inventories 18 Prepaid expenses and other 19 Total current assets 20 Property, plant and equipment 21 Goodwill 22 Other assets 23 Total assets 24 Liabilities and Stockholder Equity 25 Accounts payable 26 Short-term debt 27 Total current liability 28 Long-term debt 29 Other liabilities 30 Total liabilities 31 Stockholder equity 32 B Walmart 469,162 352,488 116,674 88,873 27,801 2,251 187 25,737 7,981 17,756 7,781 6,768 43,803 1,588 59,940 116,681 20,497 5,987 203,105 59,099 12,719 71,818 41,417 113,235 89,870 C Macy's 27,931 16,725 11,206 8,440 88 2,678 388 (134) 2,156 767 1,389 1,836 371 5,308 361 7,876 8,196 3,743 1,176 20,991…
Suppose a firm has had the historical sales figures shown as follows. What would be the forecast for next year's sales using the average approach? Year 2017 2018 Sales $ 750,000 500,000 Multiple Choice O $695,000 $700,000 $750,000 $775.000 2019 $ 700,000 2020 $ 750,000 2021 $ 775,000
Calculate the projected price/earnings ratio and market/book ratio. Explain whether these ratios indicate that investors will be expected to have a high or low opinion of the company. Computron's Balance Sheets (Millions of Dollars) 2019 2020 Assets Cash and equivalents $ 60 $ 50 Short-term investments 100 10 Accounts receivable 400 520 Inventories 620 820 Total current assets $ 1,180 $ 1,400 Gross fixed assets $ 3,900 $ 4,820 Less: Accumulated depreciation 1,000 1,320 Net fixed assets $ 2,900 $ 3,500 Total assets $ 4,080 $ 4,900 Liabilities and equity Accounts payable $ 300 $ 400 Notes payable 50 250 Accruals 200 240 Total current liabilities $ 550 $ 890 Long-term bonds 800 1,100 Total liabilities $ 1,350 $ 1,990 Common stock 1,000 1,000 Retained earnings 1,730 1,910 Total equity $ 2,730 $ 2,910 Total liabilities and equity $ 4,080 $ 4,900…
Shamal Plastics Industries Sohar, is one of the leading plastic sheets manufacturing companies in Sultanate of Oman. While preparing the financial statement for the year 2020, some of the earnings reported in the year 2021 has been shifted to 2020. This denotes that Shamal Plastics Industries management might have followed O a. The political cost hypothesis Ob. The debt covenant hypothesis or political cost hypothesis. Oc The bonus plan hypothesis or political cost hypothesis. Od The bonus plan hypothesis or debt covenant hypothesis.
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. Please provide the solutions for the EPS, DPS, 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.
Refer to the following financial statements for Kodenko Inc: Prepare forecasts of its income statement, statement of financial position and statement of cash flows for 2020 under the following assumptions:a. All financial ratio remains at 2019 level.b. Kodenko will not record restructuring costs for 2020.c. Taxes payable are at the 2019 level of RM544 million.d. Depreciation expense charged to Selling, general and administrative is RM765million for 2019 and 2018 repectively.e. Gross PPE is RM 12,982 million and RM12,963 million for 2019 and 2018 respectively.f. Projected current maturities of long term debt are RM13 million for 2020.g. Capital expenditure for 2019 and 2018 are RM1,047 and RM783, respectively
Calculate the following leverage ratios for 2020. Debt ratio- Debt-to-equity- Times interest earned ratio-
Suppose a firm has had the following historic sales figures. What would be the forecast for next year's sales using the average approach? You must use the built-in Excel function to answer this question. Input area: Year Sales 2016 2017 2018 es es e $ 1,500,000 $ 1,750,000 $ 1,400,000 2019 $ 2,000,000 2020 $ 1,600,000 Output area: Next year's sales