Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the following information and answer the questions Assumptions ARPU - Average Revenue per User (annual, beginning customers) $ Customer Assumptions Customer Acquisition Expense (per

Use the following information and answer the questions
Assumptions ARPU - Average Revenue per User (annual, beginning customers) $ Customer Assumptions Customer Projected investment into inventory between 2021 and 2022? Present value of the equity? Projected dividends paid in 2021? Projected capex in 2022? Projected accounts payable in 2021? Projected PROCEEDS from common stock during the year 2022? 

Assumptions ARPU - Average Revenue per User (annual, beginning customers) $ Customer Assumptions Customer Acquisition Expense (per new customer) Customer Churn (% of beginning customers who quit service) Cost of Goods Sold per User (use beginning customers) SG&A expense: Total Customer Acquisition Marketing Expense Other SG&A expenses Capital Expenditures (Capex) Depreciation (% of lagged fixed assets) Interest Expense (% of lagged NP and LTD) Average Tax Rate $ Required Cash Days Sales in Inventory Days Sales in Receivables Days Payables Outstanding Capital Structure Decisions Dividend Payout Ratio Planned LTD (year end) Equity Account (Par + APIC) $ "Success-Based" Capex (capital expenditures / new customer) $ "Maintenance" Capex $ $ 2020 1,200 $ 400 $ 10% 400 $ 2021 1,500 $ 10% 10% 25% 450 $ 20% 500 $ 120,000 $ 150,000 $ 180,000 80,000 $ 100,000 $100,000 800 $ 600 $ Equals Depreciation Expense 0% 500,000 2,750,000 10% 10% 25% Equal to Accounts Payable 73 40 30 2022 1,800 73 45 30 10% 600,000 2,750,000 450 20% 600 500 10% 10% 25% 73 45 30 25% 700,000 2,600,000 Assumptions ARPU - Average Revenue per User (annual, beginning customers) $ Customer Assumptions Customer Acquisition Expense (per new customer) Customer Churn (% of beginning customers who quit service) Cost of Goods Sold per User (use beginning customers) SG&A expense: Total Customer Acquisition Marketing Expense Other SG&A expenses Capital Expenditures (Capex) Depreciation (% of lagged fixed assets) Interest Expense (% of lagged NP and LTD) Average Tax Rate $ Required Cash Days Sales in Inventory Days Sales in Receivables Days Payables Outstanding Capital Structure Decisions Dividend Payout Ratio Planned LTD (year end) Equity Account (Par + APIC) $ "Success-Based" Capex (capital expenditures / new customer) $ "Maintenance" Capex $ $ 2020 1,200 $ 400 $ 10% 400 $ 120,000 $ 80,000 $ 10% 10% 25% 2021 1,500 $ 450 $ 20% 500 $ 0% 500,000 2,750,000 800 $ 600 $ Equals Depreciation Expense 150,000 $ 180,000 100,000 $ 100,000 10% 10% 25% Equal to Accounts Payable 73 40 30 2022 1,800 73 45 30 10% 600,000 2,750,000 450 20% 600 500 10% 10% 25% 73 45 30 25% 700,000 2,600,000

Step by Step Solution

3.47 Rating (167 Votes )

There are 3 Steps involved in it

Step: 1

To calculate the projected investment into inventory between 2021 and 2022 we need to first calculate the projected cost of goods sold COGS for 2022 Projected COGS for 2022 Projected COGS for 2022 Pro... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Elizabeth A. Gordon, Jana S. Raedy, Alexander J. Sannella

1st edition

978-0133251579, 133251578, 013216230X, 978-0134102313, 134102312, 978-0132162302

More Books

Students also viewed these Accounting questions

Question

Explain the five different types of auditors opinions.

Answered: 1 week ago