Don Williams received a memo requesting that he complete a trend analysis of the following numbers using 2018 as the base year.2019$420,000340,00040,000SalesGross profitNet income2021$340,000180,00070,000SalesGross profitNet incomeCould you help Don with the request? (Round your answers to the nearest whole percent.)20212020$400,000240,00090,000%%%2020%%%20192018$500,000400,00050,000%%%2018Check my work100 %100 %100 %

Trend analysis :— It is calculated by dividing amount of any year by amount of base year. Trend…

Answered: Don Williams received a memo requesting…

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

Provided below are an analyst's forecasts of revenue, net operating profit after tax (NOPAT), and net operating assets (NOA) as of 12/31/2020 for Abbott Laboratories. ($ millions) Reported 2020 2021 Revenue: NOPAT: NOA: Forecast Horizon Period 2022 2023 $34,608.0 $36,684.5 $38,885.5 $41,218.7 $43,691.8 $4,774.4 $5,060.9 $5,364.5 $5,686.4 $6,027.6 $44,579.0 $47,253.7 $50,089.0 $53,094.3 $56,280.0 2024 Terminal Period The following additional information is provided (dollar and share amounts in millions). Common shares outstanding: 1,771.230 Net nonoperating obligations (NNO): $11,576.0 Noncontrolling interest (NCI): $219.0 Preferred stock: $0.0 WACC: 4.0% Terminal growth: 2.0% According to the DCF model, what is the total value of the firm? According to the DCF model, what is the value per share of common stock? Use the discounted cash flow (DCF) method to answer the following questions. Do not round intermediate calculations. All values other than per-share amounts are shown in…
Examine the selected data over the 5-year period as shown in the table below for Dumbledore Ltd. Item Sales Cost of sales EBIT Interest NPAT Current assets Total assets current liabilities Total liabilities Equity Gross margin Interest coverage Current ratio 2021 $m 286.41 180.03 51.18 37.07 35.13 43.85 226.18 55.99 98.99 127.19 0.37 1.38 0.78 Year 2020 $m 280.80 166.69 51.08 33.70 35.10 43.20 221.75 53.58 91.66 130.09 0.41 1.52 0.81 2019 $m 275.29 154.35 50.98 30.64 35.06 42.56 217.40 51.27 84.87 132.53 0.44 1.66 0.89 2018 $m 269.89 142.91 50.88 27.85 35.03 41.93 213.13 49.06 78.58 134.56 0.47 1.83 U.OJ 2017 $m 264.60 134.19 49.88 25.32 34.51 41.31 206.93 47.40 74.48 132.44 0.49 1.97 0.87 2016 $m 252.00 126.00 48.90 24.00 34.00 40.70 200.90 45.80 70.60 130.30 0.50 2.04 0.89
Home Security Systems is analyzing the purchase of manufacturing equipment that will cost $56,000. The annual cash inflows for the next three years will be: Year 1 2 3 Cash Flow $ 28,000 26,000 21,000 Use Appendix B and Appendix D for an approximate answer but calculate your final answer using the financial calculator method. a. Determine the internal rate of return. Note: Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. Internal rate of return %
music studio predicts its future yearly net income (loss) to be as follows: Year 1: - $120Year 2: + $20Year 3: + $90Year 4: - $10Year 5: + $30Year 6: + $30Year 7: + $30Year 8: + $40 What is the NPV of the company, considering a discount rate of 10%?
AFN equation Broussard Skateboard's sales are expected to increase by 25% from $8.4 million in 2019 to $10.50 million in 2020. Its assets totaled $4 million at the end of 2019. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2019, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 3%, and the forecasted payout ratio is 40%. Use the AFN equation to forecast Broussard's additional funds needed for the coming year. Enter your answer in dollars. For example, an answer of $1.2 million should be entered as $1,200,000. Do not round intermediate calculations. Round your answer to the nearest dollar.
Sales SOLVE IT ON MS EXCEL or GOOGLE SPREADSHEET (please send the file) Ziegen, Inc. Income Statement for 2013 Make a Proforma Income Statement and ProForma Balance Sheet using the Financial Planning attached. Use 15% as the Sales Growth Rate of the 2013 base year, all other data remain the same. Net Income Ziegen, Inc. Balance Sheet for 2013 Current assets Net fixed assets Total Total Accounts payable Accrued expenses Notes payable Current liabilities Long-term debt Total liabilities Common stock (par) Paid-in capital Retained earnings Common equity $10,000,000 $ 500,000 $ 2,000,000 4,000,000 $ 6,000,000 $ 1,000,000 1,000,000 500,000 $ 2,500,000 2,000,000 $ 4,500,000 100,000 200,000 1,200,000 $ 1,500,000 $6,000,000 Calculation $.5m/$10m = Calculation $2m/$10m = $4m/$10m = $1m/$10m = $1m/$10m = Ziegen, Inc. Pro Forma Income % of 2013 Sales Statement for 2014 5.0% % of 2013 Sales 20.0% 40.0% 10.0% 10.0% NAª NA NA" NA" Calculation 20% Sales growth rate = Sales Net Income Ziegen, Inc. Pro…
Calculate the continuation value of KMS using the following table, and assuming an EBITDA multiple of 8.5. (Click on the following icon in order to copy the contents of the table below into a spreadsheet.) -2019 $16,476 2020 $18,116 The continuation value is $ 2021 $19,875 2022 $21,792 thousand. (Round to the nearest integer.) 2023 $23,882 EBITDA (000) The Tax Cuts and Jobs Act of 2017 temporarily allows 100% bonus depreciation (effectively expensing capital expenditures). However, we will still include depreciation forecasting in this chapter and in these problems in anticipation of the return of standard depreciation practices during your career. 2024 $26,162
Requirements 1. Prepare a comparative common-size income statement for Mariner Designs, Inc. using the 2024 and 2023 data. Round percentages to one-tenth percent. 2. To an investor, how does 2024 compare with 2023 ? Explain your reasoning
AFN equation Broussard Skateboard's sales are expected to increase by 25% from $8.6 million in 2019 to $10.75 million in 2020. Its assets totaled $3 million at the end of 2019. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2019, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 5%, and the forecasted payout ratio is 50%. Use the AFN equation to forecast Broussard's additional funds needed for the coming year. Enter your answer in dollars. For example, an answer of $1.2 million should be entered as $1,200,000. Do not round intermediate calculations. Round your answer to the nearest dollar. $
Google Calendar Use the following table and information to answer questions 26 and 27 The following table presents forecasted financial and other information for XTD Corporation. The table shows end of year numbers (in millions). XTD's WACC is 8%. Year 1 Year 2 Year 3 Net income $65 $72 $80 Free cash flow $40 $45 $50 26) What is an appropriate estimate of XTD's terminal value as of today, using warranted price-to-earnings of 12.0 at year 3? $ 1,036.8 million $ 895.2 million $ 762.1 million O $ 888.8 million
Net sales revenue, net income, and common stockholders' equity for Eyesight Mission Corporation, a manufacturer of contact lenses, follow for a four-year period. E (Click the icon to view the net sales revenue, net income, and common equity) Read the requirements. Requirement 1. Compute trend analyses for each item for 2017-2019. Use 2016 as the base year, and round to the nearest whole percent. Begin by computing Eyesight Mission Corporation's trend analysis for net sales revenue, then compute Eyesignt Mission Corporation's trend analysis for net income and finally compute Eyesight Mission Corporation's trend analysis for com 2019 2018 2017 2016 Net Sales Revenue 766,000 708,000 644.000 664,000 Trend Percentages 115 % 107 % 97 % 100 % Net Income 60,000 $4 38,000 $ 36.000 2. 44.000 Trend Percentages 136 % 86 % 82 % 100 % Ending Common Stockholdors' Equity 368,000 352 000 $ 326,000 $ 296,000 Trend Percentages 124 % 119 % 110 100 % % OTI Requirement 2. Compute the rate of return on…
Accounting Rate of Return Vanderhoort Company invested $10,370,000 in a new product line. The life cycle of the product is projected to be seven years with the following net income stream: $360,000, $360,000, $600,000, $1,080,000, $1,200,000, $2,520,000, and $1,444,000. Required: Calculate the ARR. Enter your answer as a decimal, do not convert to a percent. Round your answer to two decimal places.

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS