Question

Jim's Espresso expects sales to grow by 10.2 % next year. Using the following statements and...

Jim's Espresso expects sales to grow by 10.2 % 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.)

Income Statement  
Sales   $208,110
Costs Except Depreciation   (99,770)
EBITDA   $108,340
Depreciation   (5,900)
EBIT   $102,440
Interest Expense (net)   (520)
Pretax Income   $101,920
Income Tax   (35,672)
Net Income   $66,248

Balance Sheet

Assets Cash and Equivalents $15,020

Accounts Receivable 2,030

Inventories 3,930

Total Current Assets $20,980

Property, Plant and Equipment 10,100

Total Assets $31,080

Liabilities and Equity Accounts Payable $1,400

Debt 4,060 Total Liabilities $5,460

Stockholders' Equity 25,620

Total Liabilities and Equity $31,080

Homework Answers

Answer #1
Present Calculation Forcasted
Sales 208,110 (208,110*110.2%) 229,337.22
a. Costs 99,770 (99,770/208,110*229,337.22) 109,946.54
b. Depreciation 5,900 (5,900/208,110*229,337.22) 6,501.80
c. Net Income 66,248 (66,248/208,110*229,337.22) 73,005.30
d. Cash 15,020 (15,020/208,110*229,337.22) 16,552.04
e. Accounts receivable 2,030 (2,030/208,110*229,337.22) 2,237.06
f. Inventory 3,930 (3,930/208,110*229,337.22) 4,330.86
g.​ Property, plant, and equipment 10,100 (10,100/208,110*229,337.22) 11,130.20
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Based on​ Jim's expectation of 9.9% sales growth and payout ratio of 89.86% of net income...
Based on​ Jim's expectation of 9.9% sales growth and payout ratio of 89.86% of net income next​ year, Jim developed the pro forma financial statements given below. What is the amount of net new financing needed for​ Jim's Espresso?  Income Statement Balance Sheet       Sales   $222,405 Assets       Costs Except Depreciation   (109,120) Cash and Equivalents   $16,375   EBITDA   $113,285    Accounts Receivable   2,308   Depreciation   (6,616) Inventories   4,484   EBIT   $106,669 Total Current Assets   $23,167   Interest Expense (net)   (429) Property, Plant, and Equipment  ...
spreadsheet. Income Statement​ ($ million) Balance Sheet​ ($ million) Net Sales 186.2186.2 Assets Costs Except Depreciation...
spreadsheet. Income Statement​ ($ million) Balance Sheet​ ($ million) Net Sales 186.2186.2 Assets Costs Except Depreciation negative 175.9−175.9 Cash 22.222.2 EBITDA 10.310.3 Accounts Receivable 17.917.9 Depreciation and Amortization negative 1.3−1.3 Inventories 15.715.7 EBIT 99 Total Current Assets 55.855.8 Interest Income​ (expense) negative 7.7−7.7 Net​ Property, Plant, and Equipment 112.6112.6 ​Pre-tax Income 1.31.3 Total Assets 168.4168.4 Taxes ​(2626​%) negative 0.3−0.3 Net Income 1.01.0 Liabilities and Equity Accounts Payable 33.533.5 ​Long-Term Debt 112.3112.3 Total Liabilities 145.8145.8 Total​ Stockholders' Equity 22.622.6 Total Liabilities...
Balance Sheet The following balance sheet contains errors. ATLAS SERVICES CO. Balance Sheet For the Year...
Balance Sheet The following balance sheet contains errors. ATLAS SERVICES CO. Balance Sheet For the Year Ended May 31, 20Y5 Assets   Current assets:   Cash $ 12,000   Accounts payable 47,900   Supplies 4,800   Prepaid insurance 17,400   Land 400,000   Total current assets $482,100 Property, plant, and equipment:   Building $ 225,000   Equipment 90,000   Total property, plant, and equipment 315,000 Total assets $797,100 Liabilities Current liabilities:   Accounts receivable $ 40,800   Accumulated depreciation—building 54,600   Accumulated depreciation—equipment 32,400   Net loss 44,200 Total liabilities $172,000 Stockholders’ Equity   Wages...
Use the following Income Statement and Balance Sheet of firm X to answers Questions (1) &...
Use the following Income Statement and Balance Sheet of firm X to answers Questions (1) & (2) Income Statement, 2016 Balance Sheet, 2016 Sales 5,000,000 Assets Costs except Depr. -3,500,000 Cash and Equivalents 1,096,000 EBITDA 1,500,000 Accounts Receivable 960,000 Depreciation -10,900 Inventories 90,000 EBIT 1,489,100 Total Current Assets 2,146,000 Interest Expense (net) -100,500 Property Plant & Equipment 2,190,000 Pretax Income 1,388,600 Total Assets 4,336,000 Income Tax -486,010 Liabilities &Equity Net Income 902,590 Accounts Payable 900,000 Debt 950,000 Total Liabilities 1,850,000...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 25 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement   Sales $ 760,000   Costs 595,000   Other expenses 31,000   Earnings before interest and taxes $ 134,000   Interest paid 27,000   Taxable income $ 107,000   Taxes (22%) 23,540...
The most recent financial statements for Fleury Inc., follow. Sales for 2015 are projected to grow...
The most recent financial statements for Fleury Inc., follow. Sales for 2015 are projected to grow by 25 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets and accounts payable increase spontaneously with sales. FLEURY, INC. 2014 Income Statement   Sales $ 750,000   Costs 585,000   Other expenses 21,000   Earnings before interest and taxes $ 144,000   Interest paid 17,000   Taxable income $ 127,000   Taxes (20%) 25,400...
The most recent financial statements for Fleury Inc., follow. Sales for 2015 are projected to grow...
The most recent financial statements for Fleury Inc., follow. Sales for 2015 are projected to grow by 20 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets and accounts payable increase spontaneously with sales. FLEURY, INC. 2014 Income Statement   Sales $ 755,000   Costs 590,000   Other expenses 11,000   Earnings before interest and taxes $ 154,000   Interest paid 12,000   Taxable income $ 142,000   Taxes (40%) 56,800...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 20 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement   Sales $ 753,000   Costs 588,000   Other expenses 24,000   Earnings before interest and taxes $ 141,000   Interest paid 20,000   Taxable income $ 121,000   Taxes (25%) 30,250...
FREE CASH FLOW Arlington Corporation’s financial statements (dollars and shares are in millions) are provided here....
FREE CASH FLOW Arlington Corporation’s financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2018                     2017 Assets Cash and equivalents                      $ 15,000               $ 14,000 Accounts receivable                        35,000                   30,000 Inventories                                         33,320                   27,000 Total current assets                        $ 83,320               $ 71,000 Net plant and equipment             48,000                  46,000 Total assets                                        $131,320             $ 117,000 Liabilities and Equity Accounts payable                             $ 10,100               $ 9,000 Accruals                                              ...
FORECAST BALANCE SHEET IF THEIR SALES INCREASE 20%. Sales/Revenu=89,219.2 Saudee Group Bhd SAUDEE (Malaysia) BALANCE SHEET...
FORECAST BALANCE SHEET IF THEIR SALES INCREASE 20%. Sales/Revenu=89,219.2 Saudee Group Bhd SAUDEE (Malaysia) BALANCE SHEET Assets Fiscal year is August-July. All values MYR Thousands. 2018 Cash & Short Term Investments 6,144.4 Cash Only 6,144.4 Short-Term Investments - Total Accounts Receivable 19,826.8 Accounts Receivables, Net 17,010.5 Accounts Receivables, Gross 20,718.1 Bad Debt/Doubtful Accounts (3,707.6) Other Receivables 2,816.2 Inventories 33,732.0 Finished Goods 16,369.2 Work in Progress - Raw Materials 17,362.8 Other Current Assets 2,668.3 Prepaid Expenses 2,630.3 Miscellaneous Current Assets 38.0...