Question

M'USD 2018 2019 2020 Revenue                   120                   13

M'USD 2018 2019 2020
Revenue                   120                   133                   160
PPE Gross beginning balance                     56                     74                     94
Accumulated Depreciation beginning balance                   (16)                   (22)                   (29)
Depreciation for the year                       5                       6                       7
Capital expenditures during the year                   (18)                   (20)                   (22)

Based on that information and using the same ratios as in the last year as well as last year's growth rate in revenue for 2021 you forecast:
Assume CAPEX is made at the end of the year.


Select one or more:

a. CAPEX in 2021 is around 26.5M

b. Using depreciation to Capex ratio depreciation expense in 2021 is around 8.4M

c. The Net PPE in 2020 is 146M

d. The BOP Gross PPE is 130M in 2021

e. EOP net PEE in 2021 is around 186.5M

Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1
Financial Forecasting for 2021
M 'USD
Particulars 2018 2019 2020 2021
Revenue 120 133 160 192.48
PPE Gross beginning balance 56 74 94 116
Accumulated Depreciation beginning balance (16) (22) (29) 37
Depreciation for the year 5 6 7 8
Capital expenditures during the (18) (20) (22) (24)
WN 1 : Sales growth rate in 2020 ((160-133)/133*100) = 20.30 %
So, Revenue for 2021 shall be in same growth as (160*120.30%) = M'USD 192.48
WN 2: PPE Gross beginning balance = Last year beginning balance + capital expenditures during the last year
PPE Gross beginning balance in 2021 (94 + 22) = M'USD 116
WN 3: Estimated CAPEX at the end of the year is M'USD 2 as same expenditure maintained with same growth
of company.
WN 4: Depreciation for the year shall be increased by M'USD 1, so it will be M'USD 8 for 2021 as same growth
in capital expenditure noted as last year.

Select one or more:

 Answer
a. CAPEX in 2021 is around 26.5M CAPEX in 2021 is 24 M. So 26.5 M is wrong.
b. Using depreciation to Capex ratio depreciation expense in 2021 is around 8.4M Using depreciation to CAPEX ratio depreciation to be M 7.64 (7/22*24)
So 8.4 M is wrong.
c. The Net PPE in 2020 is 146M Net PPE in 2020 is M 80 (94+22-29-7). So 146M is wrong
d. The BOP Gross PPE is 130M in 2021 Gross PPE is M 140 (116+24). So 130M is wrong
e. EOP net PEE in 2021 is around 186.5M Opening net PPE in 2021 is M 79 (116-37). So 186.5 M is wrong.
As answer given based on the forecast inspired by the assumption as made. No any option matched or selected.
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Adjusting entries: Prepare the adjusting entries needed at December 31, 2020.If no entry is needed, write...
Adjusting entries: Prepare the adjusting entries needed at December 31, 2020.If no entry is needed, write NONE. 1.   Interest on a $ 42,000, 7%, six-year note payable was last paid on September 1, 2019. 2.   On May 31, 2020, Maison entered into a contract to provide services to a customer for 18 months beginning June 1. The customer paid the $ 18,000 fee in full on June 1 and Maison credited it to Service Revenue. 3.   On August 1, 2020,...
Income Statement For the year ended December​ 31, 2019 Sales Revenue ​$347,000 Cost of Goods Sold...
Income Statement For the year ended December​ 31, 2019 Sales Revenue ​$347,000 Cost of Goods Sold ​(78,000) Gross Profit ​$269,000 Selling and Administrative Expenses ​(43,900) Operating Income ​225,100 Gain on Sale of Equipment ​5,500 Net Income ​$230,600 All of the​ company’s sales are made on account. At the beginning of the​ year, the Accounts Receivable balance was​ $53,500. The balance had decreased to​ $50,200 by​ year-end. All of the​ company’s inventory purchases are made on account. Accounts Payable consists solely...
Refine Assumptions for PPE Forecast Following are the income statement and balance sheet for Medtronic PLC....
Refine Assumptions for PPE Forecast Following are the income statement and balance sheet for Medtronic PLC. Consolidated Statement of Income ($ millions) For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expenses 2,330 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit (loss) 6,268 Other nonoperating income, net (373) Interest...
Assume today is December 31, 2019. Barrington Industries expects that its 2020 after-tax operating income [EBIT(1...
Assume today is December 31, 2019. Barrington Industries expects that its 2020 after-tax operating income [EBIT(1 – T)] will be $430 million and its 2020 depreciation expense will be $65 million. Barrington's 2020 gross capital expenditures are expected to be $110 million and the change in its net operating working capital for 2020 will be $30 million. The firm's free cash flow is expected to grow at a constant rate of 5% annually. Assume that its free cash flow occurs...
Data Given: 2017 2018 2019 2020 Net sales $500 $600 $700 $760 Selling and administrative expense...
Data Given: 2017 2018 2019 2020 Net sales $500 $600 $700 $760 Selling and administrative expense 60 70 80 90 Interest 30 40 45 60 Tax rate of ACC before the merger 30% Tax rate after merger 35% Cost of goods sold as a % of sales 65% Debt ratio (percent financed with debt) before the merger 30% Cost of debt before merger 9% Debt ratio (percent financed with debt) after the merger 40% Cost of debt after merger 10%...
Condensed financial data of Larkspur Company for 2020 and 2019 are presented below. LARKSPUR COMPANY COMPARATIVE...
Condensed financial data of Larkspur Company for 2020 and 2019 are presented below. LARKSPUR COMPANY COMPARATIVE BALANCE SHEET AS OF DECEMBER 31, 2020 AND 2019 2020 2019 Cash $1,760 $1,180 Receivables 1,750 1,290 Inventory 1,620 1,890 Plant assets 1,930 1,690 Accumulated depreciation (1,280 ) (1,160 ) Long-term investments (held-to-maturity) 1,290 1,440 $7,070 $6,330 Accounts payable $1,180 $920 Accrued liabilities 200 260 Bonds payable 1,370 1,550 Common stock 1,930 1,670 Retained earnings 2,390 1,930 $7,070 $6,330 LARKSPUR COMPANY INCOME STATEMENT FOR...
Comparative balance sheets for 2021 and 2020, a statement of income for 2021, and additional information...
Comparative balance sheets for 2021 and 2020, a statement of income for 2021, and additional information from the accounting records of Red, Inc., are provided below. RED, INC. Comparative Balance Sheets December 31, 2021 and 2020 ($ in millions) 2021 2020 Assets Cash $ 37 $ 122 Accounts receivable 210 145 Prepaid insurance 11 9 Inventory 270 188 Buildings and equipment 426 363 Less: Accumulated depreciation (132 ) (253 ) $ 822 $ 574 Liabilities Accounts payable $ 100 $...
Comparative balance sheets for 2021 and 2020, a statement of income for 2021, and additional information...
Comparative balance sheets for 2021 and 2020, a statement of income for 2021, and additional information from the accounting records of Red, Inc., are provided below. RED, INC. Comparative Balance Sheets December 31, 2021 and 2020 ($ in millions) 2021 2020 Assets Cash $ 31 $ 150 Accounts receivable 255 239 Prepaid insurance 6 2 Inventory 215 100 Buildings and equipment 492 357 Less: Accumulated depreciation (126 ) (247 ) $ 873 $ 601 Liabilities Accounts payable $ 85 $...
Forecast the Statement of Cash Flows The following are the income statements and balance sheets of...
Forecast the Statement of Cash Flows The following are the income statements and balance sheets of Amazon.com Inc.   AMAZON.COM INC. Consolidated Statement of Operations $ millions 2016 Estimated Dec. 31, 2015 Net product sales $91,158 $79,268 Net service sales 38,833 27,738 Total net sales 129,991 107,006 Operating expenses Cost of sales 87,094 71,651 Fulfillment 16,249 13,410 Marketing 6,370 5,254 Technology and content 15,209 12,540 General and administrative 2,080 1,747 Other operating expense (income), net 171 171 Total operating expenses 127,173...
QUESTION 1 Select the Sources of Funds that would be included on the Statement of Cash...
QUESTION 1 Select the Sources of Funds that would be included on the Statement of Cash Flows. Increase in Bank Notes Decrease in Bank Notes Net Income Increase in Accounts Payable Increase in Investments Depreciation Decrease in Investments Capital Expenditures Calculate the Ending Cash Balance given the following information: Beginning Cash Balance (1/1/XX): $20,000 Sources of Funds: $15,000 Uses of Funds: $25,000 Ending Cash Balance: ? QUESTION 3 Dallas Company had NET sales of $1,000,000 for the year, cost of...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT