Question

In: Finance

DietWeb, Inc. BALANCE SHEET December 31, 20X8 and 20X7 (in thousands) 20X8 20X7 Assets Current assets...

DietWeb, Inc.

BALANCE SHEET

December 31, 20X8 and 20X7

(in thousands)

20X8

20X7

Assets

Current assets

Cash and cash equivalents

$3,019

$1,050

    Trade receivables

485

450

    Prepaid advertising expenses

59

609

    Prepaid expenses and other current assets

175

230

Total current assets

3,738

2,339

Fixed assets, net

3,321

3,926

Total assets

$7,059

$6,265

Liabilities and shareholders' equity

Current liabilities

    Accounts payable

$1,070

$ 909

    Current maturities of notes payable

42

316

    Deferred revenue

1,973

1,396

    Other current liabilities

171

12

Total current liabilities

3,256

2,633

Long-term debt, less current maturity

34

176

Accrued liabilities

792

690

Deferred tax liability

15

145

Total liabilities

4,097

3,644

Shareholders' equity

    Common stock

6,040

4,854

    Retained earnings

(3,078)

(2,233)

Total shareholders' equity

2,962

2,621

Total liabilities plus shareholders' equity

$7,059

$6,265

DietWeb, Inc.

INCOME STATEMENT

Two Years Ended December 31, 20X8 and 20X7

(in thousands)

20X8

20X7

Revenue

$19,166

$14,814

Costs and expenses

Cost of revenue

2,326

1,528

Product development

725

653

Sales and marketing

13,903

8,710

General and administrative

2,531

2,575

Interest Expense

13

22

Depreciation and amortization

629

661

Impairment of intangible assets

35

--

    Total costs and expenses

20,162

14,149

Net income before taxes

(970)

665

Income tax benefit

129

125

Net income (loss)

$ (841)

$ 790

DietWeb, Inc.

STATEMENT OF CASH FLOWS

Year Ended December 31, 20X8

20X8

20X7

Cash flows from operations

Net income (loss)

$(841)

790

Adjustments to net income

Depreciation

629

660

Increase in receivables

(35)

(47)

Decrease (Increase) in prepaid advertising

550

(650)

Decrease in other current assets

55

74

Increase (Decrease) in accounts payable

161

(540)

Increase in accrued liabilities

102

43

Increase (Decrease) in deferred revenue

432

(665)

Increase in common stock issued

1,186

--

Increase in other current liabilities

159

43

Net cash provided (used) by operations

2,372

(292)

Cash flows from operations

Purchase of property and equipment

(320)

2,016

Cash flows from financing activities

New debt

613

40

Debt payments

(718)

(918)

Net cash provided (used) by financing activities

(105)

(878)

Net increase in cash and cash equivalents

$1,947

846

Cash and equivalents at beginning of year

$1,072

204

Cash and equivalents at end of year

$3,019

1050

1-REVENUE/SALES- Based on economic conditions, she believes that the increase in sales for the current year should approximate the historical trend. (Revenues were 20x6: $11,814 20x5: $9,500, 20x4: $7,800) (Industry sales have been increasing by double digits for the last five years, competitor sales increases have ranges from 10-30% increases year over year for the last 5 years.) Using a reasonableness analytic estimate expected revenue for 2018 using the historical data provided.

2.Based on her knowledge of economic conditions, she is aware that the effective interest rate on the company's Long-term debt, less current maturity for 20X8 was approximately 11 percent. She is aware that the company pays little to no interest on the current portion of the long-term debt. Long-term debt, less current maturity is the company’s only debt, and source of interest expense. Using a reasonableness analytic estimate expected interest expense for 20X8. (Show your calculation, your answer, and if any differences noted are material or not, conclude whether you believe this account is misstated or appears reasonable.)

Solutions

Expert Solution

Growth for last three years based on the information provided

Average growth rate = 23.8% in last three years.

Hence, considering this historical trend and industry competitors are growing in the range of 10-30%,

And on conservative basis applying average of historical growth rate, Revenue for 2018 would be

= 14814*23.8% = 18346.96 (in '000s)

Also, we can see that growth rate has been increasing each year by 1-3%, hence, if add 3 percantage points to growth rate of 2017, then the revenue of 19166 mentioned in the question is reasonable (19166 representts growth rate of 29.4%)

Answer for 2

Long term debt excluing current maturites in 2017 = $176,000

Now applying 11% rate of interest on $176,000, we get expected interest payment as 11%*176,000

= $19,360

This amount is less than the amount mentioned ($22,000) in the P&L statement

Here, we have used $176,000 for calculation of interest since thats the value of debt at the year end and interest on the same will be paid for the next year


Related Solutions

BALANCE SHEET December 31, 20X8 and 20X7 (in thousands) 20X8 20X7 Assets Current assets Cash and...
BALANCE SHEET December 31, 20X8 and 20X7 (in thousands) 20X8 20X7 Assets Current assets Cash and cash equivalents $3,019 $1,050     Trade receivables 485 450     Prepaid advertising expenses 59 609     Prepaid expenses and other current assets 175 230 Total current assets 3,738 2,339 Fixed assets, net 3,321 3,926 Total assets $7,059 $6,265 Liabilities and shareholders' equity Current liabilities     Accounts payable $1,070 $ 909     Current maturities of notes payable 42 316     Deferred revenue 1,973 1,396     Other current liabilities 171 12 Total current...
Presented below is the balance sheet for HHD, Inc., at December 31, 2018. Current assets $...
Presented below is the balance sheet for HHD, Inc., at December 31, 2018. Current assets $ 656,000 Investments 542,000 Property, plant, and equipment 2,392,000 Intangible assets 228,000 Total assets $ 3,818,000 Current liabilities $ 456,000 Long-term liabilities 722,000 Shareholders' equity 2,640,000 Total liabilities and shareholders' equity $ 3,818,000 The captions shown in the summarized statement above include the following: Current assets: cash, $164,000; accounts receivable, $214,000; inventories, $239,000; and prepaid insurance, $39,000. Investments: investments in common stock, short term, $104,000,...
Presented below is the balance sheet for HHD, Inc., at December 31, 2018. Current assets $...
Presented below is the balance sheet for HHD, Inc., at December 31, 2018. Current assets $ 656,000 Investments 542,000 Property, plant, and equipment 2,392,000 Intangible assets 228,000 Total assets $ 3,818,000 Current liabilities $ 456,000 Long-term liabilities 722,000 Shareholders' equity 2,640,000 Total liabilities and shareholders' equity $ 3,818,000 The captions shown in the summarized statement above include the following: Current assets: cash, $164,000; accounts receivable, $214,000; inventories, $239,000; and prepaid insurance, $39,000. Investments: investments in common stock, short term, $104,000,...
Stealcase’s Balance Sheet, as of December 31(thousands of dollars)                                 
Stealcase’s Balance Sheet, as of December 31(thousands of dollars)                                              2017      2018                                                                            2017      2018 Cash                                 30            25                  Account Payable                                  35          50 Accts Receivable          5              20                  Bank Loan                                            25           25 Inventory                        100         100                Accrued Taxes                                   15          25 Current Assets              135          245                Long Term, Dept current portion    12         12                                                                                  Current Liabilities                                87         112 Net Plant & Equip           200          250                 Long-Term Dept                                100        95                                                                                  Common Stock (10,000 shares)    100      100                                                                                 Additional paid-in...
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows:    Current Assets...
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows:    Current Assets Liabilities Cash $ 17,000 Accounts payable $ 19,000 Accounts receivable 22,000 Notes payable 27,000 Inventory 32,000 Bonds payable 57,000 Prepaid expenses 12,700 Fixed Assets Stockholders’ Equity Gross plant and equipment $ 257,000 Preferred stock $ 27,000 Less: Accumulated depreciation 51,400 Common stock 62,000 Paid in Capital 32,000 Net plant and equipment $ 205,600 Retained earnings 65,300 Total assets $ 289,300 Total liabilities and stockholders’...
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows:    Current Assets...
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows:    Current Assets Liabilities Cash $ 30,000 Accounts payable $ 32,000 Accounts receivable 35,000 Notes payable 40,000 Inventory 45,000 Bonds payable 70,000 Prepaid expenses 14,000 Fixed Assets Stockholders’ Equity Gross plant and equipment $ 270,000 Preferred stock $ 40,000 Less: Accumulated depreciation 54,000 Common stock 75,000 Paid in Capital 45,000 Net plant and equipment $ 216,000 Retained earnings 38,000 Total assets $ 340,000 Total liabilities and stockholders’...
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows:    Current Assets...
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows:    Current Assets Liabilities Cash $ 13,000 Accounts payable $ 15,000 Accounts receivable 18,000 Notes payable 23,000 Inventory 28,000 Bonds payable 53,000 Prepaid expenses 12,300 Fixed Assets Stockholders’ Equity Gross plant and equipment $ 253,000 Preferred stock $ 23,000 Less: Accumulated depreciation 50,600 Common stock 58,000 Paid in Capital 28,000 Net plant and equipment $ 202,400 Retained earnings 73,700 Total assets $ 273,700 Total liabilities and stockholders’...
SPRING TRAINING INC.   Balance Sheet                             December 31, 2017 ASSETS  &nb
SPRING TRAINING INC.   Balance Sheet                             December 31, 2017 ASSETS                                                         LIABILITIES Cash                              $25,000             Accounts Payable                 $50,000 Accounts Rec.                   5,000             Mortgage Payable                 50,000 Inventory                        14,000               Supplies                            2,000             Total Liabilities                                  $100,000 Land                                18,000 Buildings      $220,000                             STOCKHOLDER EQUITY     Acc. Depr. <20,000> 200,000           Equipment     200,000                             Common Stock $5 Par      $30,000     Acc. Depr <14,000> 186,000             Excess of Par                     $300,000                                                                   Retained Earnings               20,000                                                                    Total Equity                                     $350,000 TOTAL ASSETS        $450,000              TOTAL LIAB. & EQUITY        ...
Sanchez, Inc. reports the following liabilities (in thousands) on its December 31, 2022, balance sheet and...
Sanchez, Inc. reports the following liabilities (in thousands) on its December 31, 2022, balance sheet and notes to the financial statements. Accounts payable $4,263.9 Mortgage payable $6,746.7 Unearned rent revenue 1,058.1 Notes payable (due in 2025) 335.6 Bonds payable 1,961.2 Salaries and wages payable 858.1 Current portion of mortgage payable 1,992.2 Notes payable (due in 2023) 2,563.6 Income taxes payable 265.2 Warranty liability—current 1,417.3 Prepare the liabilities section of Sanchez’s balance sheet as at December 31, 2022.
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows: Current Assets Liabilities...
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows: Current Assets Liabilities Cash $ 15,000 Accounts payable $ 17,000 Accounts receivable 20,000 Notes payable 25,000 Inventory 30,000 Bonds payable 55,000 Prepaid expenses 12,500 Fixed Assets Stockholders’ Equity Gross plant and equipment $ 255,000 Preferred stock $ 25,000 Less: Accumulated depreciation 51,000 Common stock 60,000 Paid in Capital 30,000 Net plant and equipment $ 204,000 Retained earnings 69,500 Total assets $ 281,500 Total liabilities and stockholders’ equity...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT