Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cash Flow Exercise: Fill in the missing information in the table below using the information provided. Use the table on p. 3-10 of the Participants

Cash Flow Exercise:

Fill in the missing information in the table below using the information provided. Use the table on p. 3-10 of the Participants Manual (textbook) as a guide. If you dont see a line item in the table, assume these accounts dont exist. Be sure to indicate whether each item is positive (increase in cash) or negative (decrease in cash).

12/31/19 Balance

12/31/20 Balance

Income Statement

Cash Impact

Subtotal

Net Sales

X

X

1,750,000

1,750,000

1,750,000

Accounts Rec

250,000

300,000

X

(50,000)

CASH FROM SALES

X

X

X

X

Cost of Goods Sold

X

X

820,000

(820,000)

Inventory

400,000

300,000

X

Accounts Payable

175,000

200,000

X

CASH PRODUCTION COSTS

X

X

X

X

SG&A Expenses

X

X

600,000

(600,000)

Prepaid Expenses

50,000

75,000

X

CASH OPERATING EXPENSES

X

X

X

X

CASH AFTER OPERATIONS (ALSO NET CASH AFTER OPS)

X

X

X

X

Interest Expense

X

X

50,000

(50,000)

Dividends Paid

X

X

25,000

(25,000)

FINANCING COSTS

X

X

X

X

(75,000)

NET CASH INCOME

X

X

X

X

Long-Term Debt Payments

X

X

X

(175,000)

CASH AFTER DEBT AMORT

X

X

X

X

130,000

Gross Fixed Assets

800,000

950,000

X

FINANCING SURPLUS / (REQ)

X

X

X

X

Cash

50,000

30,000

X

X

Sensitivity Exercise:

Washington Accounting Company is focused 100% on preparing tax returns for personal and business clients. The company reported the following results for 2020. A new competitor has opened nearby, so the management would like to assess the impact of a 20% decline in returns prepared at the 2020 average rate. Alternatively, they feel they may be able to keep the same number of clients by dropping their average price by 25%. Calculate the impact of each of these changes individually, and as a worst-case scenario where the firm decreases its costs and business still falls by 20%, calculate the combined impact of both events.

2020 Results

20% Drop in Returns

25% Drop in Fee

Combined Impact

# of tax returns prepared (year)

1,800

Average fee per tax return

$200

Gross Revenues

$360,000

If the companys expenses and debt payments total $250,000, what is its break-even price point assuming they are able to keep the number of tax returns steady from 2020?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions

Question

Keyword That introduces an overloaded function definition

Answered: 1 week ago