Question

Jim's Espresso expects sales to grow by 10.3 % next year. Using the following statements and the percent of sales​ method, forecast:

a. Costs
b. Depreciation
c. Net Income
d. Cash
e. Accounts receivable
f. Inventory
g.​ Property, plant, and equipment ​(​Note: Make sure to round all intermediate calculations to at least five decimal​ places.)

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.



Balance Sheet
Assets
Cash and Equivalents $15,050
Accounts Receivable 2070
Inventories 4090
Total Current Assets $21,210
Property, Plant and Equipment 10050
Total Assets $31,260

Liabilities and Equity:
Accounts Payable $1,580
Debt 3930
Total Liabilities $5,510
Stockholders' Equity 25750
Total Liabilities and Equity $31,260

Income Statement:
Sales $204,560
Costs Except Depreciation (99,880)
EBITDA $104,680
Depreciation (5,960)
EBIT $98,720
Interest Expense (net) (410)
Pretax Income $98,310
Income Tax (34,409)
Net Income $63,901

The forecasted costs will be :___________

Answer 1

The forecasted costs for Jim's Espresso using the percent of sales method, given a 10.3% growth in sales, would be $110,223.

Step-by-step explanation:

First, we need to determine the sales growth to forecast the costs for Jim's Espresso using the percent of sales method. With a 10.3% growth projected, and given that last year's sales were $204,560, the forecasted sales for next year would be:

$204,560 × (1 + 10.3%) = $204,560 × 1.103 = $225,627.68
Assuming costs maintain the same relationship to sales as in the current year, we calculate forecasted costs as a percentage of the sales. The current year's costs are $99,880, approximately 48.82753% of the sales ($99,880 / $204,560). Using this percentage, the forecasted costs next year would be:

48.82753% × $225,627.68 = $110,222.64 (rounded to the nearest dollar, the forecasted costs will be $110,223).

Answer 2

Jim's Espresso

The forecasted costs will be :___________

a. Costs = $110,168

b. Depreciation = $6,575

c. Net Income = $70,482

d. Cash = $16,600

e. Accounts receivable = $2,283

f. Inventory = $4,511

g.​ Property, plant, and equipment = $11,085

Step-by-step explanation:

a) Data and Calculations:

Sales growth = 10.3%

Balance Sheet

Assets Percentage of sales

Current Forecast

Cash and Equivalents $15,050 0.07357 $16,600

Accounts Receivable 2070 0.01012 2,283

Inventories 4090 0.01999 4,511

Total Current Assets $21,210

Property, Plant and Equipment 10,050 0.04913 11,085

Total Assets $31,260

Liabilities and Equity:

Accounts Payable $1,580

Debt 3930

Total Liabilities $5,510

Stockholders' Equity 25750

Total Liabilities and Equity $31,260

Income Statement: Current % Forecast

Year

Sales $204,560 1 $225,630

Costs Except Depreciation (99,880) 0.48827 (110,168)

EBITDA $104,680 0.51173

Depreciation (5,960) 0.02914 (6,575)

EBIT $98,720 0.48260

Interest Expense (net) (410) 0.00200

Pretax Income $98,310 0.48059

Income Tax (34,409) 0.16821

Net Income $63,901 0.31238 $70,482

The forecasts are based on sales of the current year and the next year.