Question

In: Accounting

Riyadh Star, Balance Sheet Statement December 31, 2018 & December 31, 2019 2018 2019 Cash $        ...

Riyadh Star, Balance Sheet Statement December 31, 2018 & December 31, 2019
2018 2019
Cash $         104,000 $       123,250
Accounts Receivable             183,350           100,000
Inventory             250,000           210,000
Prepaid Expenses               80,000           120,000
Equipment (Net)             584,650           800,000
Total Assets $      1,202,000 $    1,353,250
Accounts Payable $         220,000 $       180,000
Salary Payable               94,000             56,250
Interest Payable               20,000             37,000
Bonds Payable             320,000           300,000
Common Shares             370,000           580,000
Retained Earnings             178,000           200,000
Total Equity and Liabilities $      1,202,000 $    1,353,250
Riyadh Star, Income Statement for the Year Ended Dec 31, 2019
Sales $      1,255,250
Cost of Goods Sold             822,000
Gross Profit          433,250
Salaries Expenses             203,945
Interest Expenses               75,000
Depreciation Expenses               60,000
Tax Expenses               42,305
Total Expenses          381,250
Net Income $        52,000

In addition:

(1) Equipment costing $215,350 was purchased and the company paid for it by issuing 10,735 shares at $10 each, and the remainder was paid in cash.

(2) The Star declared and paid cash dividends at the end of 2019.

Requirements:

(1) Prepare cash flow statement for the period ended on Dec 31, 2019 using direct method

(2) Prepare cash flow statement for the period ended on Dec 31, 2019 using indirect method

(3) Determine the balance of free cash flows on Dec 31, 2019 under both methods and comment on it.

Solutions

Expert Solution

ANSWER

CASHFLOW STATEMENT OF RIYADH STAR FOR THE YEAR ENDED 31ST DECEMBER 2019

DIRECT METHOD

CASH FLOW FROM OPERATING ACTIVITIES

$

Cash received from customers

                                                   13,38,600

Cash paid to suppliers & other expenses

                                                   (8,22,000)

Tax paid          

                                                       (42,305)

Prepaid expense

                                                       (40,000 )

Salary paid

                                                   (2,41,695 )

NET CASH PROVIDED BY OPERATING ACTIVITIES   (A)

                                                     1,92,600

CASH FLOW FROM INVESTING ACTIVITIES

EQUIPMENT PURCHASED

                                                   (1,68,000)

NET CASH USED BY INVESTING ACTIVITIES (B)

                                                   (1,68,000)

CASH FLOW FROM FINANCING ACTIVITIES

Interest expense

                                                       (58,000)

Dividend paid                                  

                                                       (30,000)

Bond paid

                                                       (20,000)

Share issued

                                                     1,02,650

NET CASH USED BY FINANCING ACTIVITIES (C)

                                                         (5,350)

NET INCREASE IN CASH (A)+ (B) + (C)

                                                         19,250

Cash at the beginning of the period

                                                     1,04,000

CASH AT THE END OF THE PERIOD

                                                     1,23,250

CASHFLOW STATEMENT OF RIYADH STAR FOR THE YEAR ENDED 31ST DECEMBER 2019

(2)    INDIRECT METHOD

CASH FLOW FROM OPERATING ACTIVITIES

$

NET INCOME

                    52,000

Add: non cash expenses

Depreciation expense

                    60,000

Change in working capital

Decrease in inventory

                    40,000

Decrease in salary payable

                           (37,750)

Increase in prepaid expense

                  (40,000)

Decrease in accounts payable

                  (40,000)

Increase in interest payable

                    17,000

Decrease in Accounts receivable

                    83,350

Decrease in bond payable

            (20,000 )

Income from financing activity

add :Interest expense

                    58,000

NET CASH PROVIDED BY OPERATING ACTIVITIES

                1,72,600

CASH FLOW FROM INVESTING ACTIVITIES

EQUIPMENT PURCHASED

              (1,68,000)

NET CASH USED BY INVESTING ACTIVITIES (B)

              (1,68,000)

CASH FLOW FROM FINANCING ACTIVITIES

Interest expense

                  (58,000)

Dividend paid                                 

                  (30,000)

Share issued

                1,02,650

NET CASH USED BY FINANCING ACTIVITIES (C)

                    14,650

NET INCREASE IN CASH              (A) + (B) + (C)

                    19,250

Cash at the beginning of the period

                1,04,000

CASH AT THE END OF THE PERIOD

                1,23,250

WORKINGS

1)

CASH RECEIVED FROM CUSTOMERS

OPENING ACCOUNTS RECEIVABLES

                         1,83,350

ADD

SALES

                      12,55,250

LESS

CLOSING ACCOUNTS RECEIVABLE

                         1,00,000

                      13,38,600

2)

SALARY PAID

OPENING SALARY PAYABLE

                            94,000

ADD

CURRENT YEAR SALARY

                         2,03,945

LESS

CLOSING SALARY PAYABLE

                            56,250

                         2,41,695

3)

DIVIDENT PAID

RETAINED EARNINGS AT THE BEGINNING

                         1,78,000

ADD

CURRENT YEAR PROFIT

                            52,000

LESS

RETAINED EARNINGS AT THE END

                         2,00,000

                            30,000

4)

PURCHASE

COST OF GOODS SOLD

                         8,22,000

LESS

OPENING STOCK

                         2,50,000

ADD

CLOSING STOCK

                         2,10,000

                         7,82,000

5)

CASH PAID TO SUPPLIERS

OPENING ACCOUNTS PAYABLE

                         2,20,000

ADD

PURCHASE

                         7,82,000

LESS

CLOSING ACCOUNTS PAYABLE

                         1,80,000

                         8,22,000

6)

INTEREST PAID

OPENING INTEREST PAYABLE

                            20,000

ADD

CURRENT YEAR INTEREST

                            75,000

LESS

CLOSING INTEREST PAYABLE

                            37,000

                            58,000

7)

ADDITIONAL EQUIPMENT PURCHASED

ADD

OPENINING BALANCE

                         5,84,650

ADD

PURCHASE

                         2,15,350

LESS

DEPRECIATION

                            60,000

LESS

CLOSING BALANCE

                         8,00,000

                           -60,000

8)

PREPAID EXPENSE

OPENING BALANCE

                            80,000

CLOSING STOCK

                         1,20,000

                           -40,000

9)

EQUIPMENT PURCHASED

ADDITIONAL EQIPMENT PURCHASE

                            60,000

ADD

PURCHASE GIVEN IN QUESTION

                         2,15,350

LESS

EQUITY ISSED

                         1,07,350

                         1,68,000

10)

BONUS PAID

ADD

OPENING BALANCE

                         3,20,000

LESS

CLOSING STOCK

                         3,00,000

                            20,000

11)

SHARE ISSUED

ADD

CLOSING STOCK

                         5,80,000

LESS

ISSUED FOR QUIPMENT PURCHASED

                         1,07,350

LESS

OPENING BALANCE

                         3,70,000

                         1,02,650

(3) Free cash flow measures the efficiency of a company in generating cash. It is used to measure whether a company have enough cash, after funding operations and capital expenditures, to pay dividends and share buybacks.

FREE CASH FLOW = OPERATING CASH FLOW – CAPITAL EXPENDITURE

In direct method,

= 192600-168000= 24600

In indirect method,

=172600-168000= 4600

Here the difference of 20000 is on account of the treatment bonus paid in both methods. In indirect method it is used for calculating the change in working capital assuming it to be a current liability whereas in direct method it is considered under financing activity not under fund from operation.


Related Solutions

Prepare a balance sheet as of December 31, 2019. BUSINESS SOLUTIONS Balance Sheet December 31, 2019...
Prepare a balance sheet as of December 31, 2019. BUSINESS SOLUTIONS Balance Sheet December 31, 2019 Assets Cash Accounts receivable Prepaid insurance Prepaid insurance Prepaid rent Office equipment Accumulated depreciation—Office equipment 0 Accumulated depreciation—Computer equipment Computer equipment 0 Total Assets 0 Liabilities Accounts payable Wages payable Unearned computer services revenue Total Liabilities 0 Equity Retained earnings Common stock Total equity $0 Total Liabilities and Equity $0 After the success of the company’s first two months, Santana Rey continues to operate...
Data Table Outdoor Adventure Company Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Assets...
Data Table Outdoor Adventure Company Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Assets Current Assets: Cash $1,398,330 $14,790 Short-term Investments, net 29,000 0 Accounts Receivable, net 1,600 6,300 Merchandise Inventory 400 0 Office Supplies 70 300 Prepaid Rent 0 2,000 Property, Plant, and Equipment: Land 615,000 75,000 Building 944,000 94,000 Canoes 13,920 13,920 Office Furniture and Equipment 140,000 0 Accumulated Depreciation—PP&E (31,920) (1,740) Total Assets $3,110,400 $204,570 Liabilities Current Liabilities: Accounts Payable $6,420 $4,400 Utilities Payable 550...
Question #5 (16 marks) Sunshine Inc. Balance sheet December 31 2019 2018 Cash 148,200 $ 76,800...
Question #5 Sunshine Inc. Balance sheet December 31 2019 2018 Cash 148,200 $ 76,800 $ Receivables 29,400 30,400 Merchandise Inventory 33,400 35,200 Property, Plant, Equipment 230,400 190,400 Accumulated Depreciation 64,000 52,800 Long-term investment 6,000 383,400$ 280,000 $ Accounts Payable 43,600 62,400 Accrued liabilities 11,200 6,400 Long-term notes payable 97,600 40,000 Common shares 49,600 8,000 Retained earnings 181,400 163,200 383,400$ 280,000 $ Sunshine Inc. Income statement For year ended December 31, 2019 Sales 627,200 $ Operating Expenses Cost of goods sold...
Deitz Corporation is projecting a cash balance of $34,200 in its December 31, 2019, balance sheet....
Deitz Corporation is projecting a cash balance of $34,200 in its December 31, 2019, balance sheet. Deitz’s schedule of expected collections from customers for the first quarter of 2020 shows total collections of $210,900. The schedule of expected payments for direct materials for the first quarter of 2020 shows total payments of $49,020. Other information gathered for the first quarter of 2020 is sale of equipment $3,420; direct labor $79,800, manufacturing overhead $39,900, selling and administrative expenses $51,300; and purchase...
Deitz Corporation is projecting a cash balance of $36,900 in its December 31, 2019, balance sheet....
Deitz Corporation is projecting a cash balance of $36,900 in its December 31, 2019, balance sheet. Deitz’s schedule of expected collections from customers for the first quarter of 2020 shows total collections of $227,550. The schedule of expected payments for direct materials for the first quarter of 2020 shows total payments of $52,890. Other information gathered for the first quarter of 2020 is sale of equipment $3,690; direct labor $86,100, manufacturing overhead $43,050, selling and administrative expenses $55,350; and purchase...
BETHESDA MINING COMPANY Balance Sheets as of December 31, 2018 and 2019 2018 2019 2018 2019...
BETHESDA MINING COMPANY Balance Sheets as of December 31, 2018 and 2019 2018 2019 2018 2019 Assets Liabilities and Owners’ Equity   Current assets   Current liabilities     Cash $ 42,646 $ 54,402      Accounts payable $ 191,422 $ 199,111     Accounts receivable 60,781 81,139      Notes payable 86,520 138,088     Inventory 127,265 193,375             Total $ 277,942 $ 337,199       Total $ 230,692 $ 328,916   Long-term debt $ 240,000 $ 176,750   Owners’ equity      Common stock and paid-in surplus $ 215,000 $ 215,000      Accumulated retained earnings 155,597 189,495...
On December 31, 2018, Alan and Company prepared an income statement and balance sheet but failed...
On December 31, 2018, Alan and Company prepared an income statement and balance sheet but failed to take into account four adjusting journal entries. The income statement, prepared on this incorrect basis, reported income before income tax of $31,000. The balance sheet (before the effect of income taxes) reflected total assets, $92,000; total liabilities, $41,000; and stockholders’ equity, $51,000. The data for the four adjusting journal entries follow: Effect of Amortization of $8,200 for the year on software was not...
Upton's balance sheet as of December 31, 2019, is shown here (millions of dollars): Cash $...
Upton's balance sheet as of December 31, 2019, is shown here (millions of dollars): Cash $ 3.5 Accounts payable $ 9.0 Receivables 26.0 Notes payable 18.0 Inventories 58.0 Line of credit 0 Total current assets $ 87.5 Accruals 8.5 Net fixed assets 35.0 Total current liabilities $ 35.5 Mortgage loan 6.0 Common stock 15.0 Retained earnings 66.0 Total assets $122.5 Total liabilities and equity $122.5 Sales for 2019 were $250 million and net income for the year was $7.5 million,...
Jafan Retailing, Balance Sheet Statement December 31, 2016 & December 31, 2017 2016 2017 Cash $   ...
Jafan Retailing, Balance Sheet Statement December 31, 2016 & December 31, 2017 2016 2017 Cash $    235,000 $    400,000 Accounts Receivable        367,200        325,000 Inventory        450,000        500,200 Prepaid Expenses        120,000        160,000 Long-term investment        100,000        300,000 Equiptment (Net)     1,050,000     1,125,000 Total Assets $ 2,322,200 $ 2,810,200 Accounts Payable $    421,000 $    411,000 Salary Payable        134,000        180,000 Interest Payable        110,000        112,000 Bonds Payable        550,000        560,000 Common Shares...
Balance Sheet as of December 31, 2018 (Thousands of Dollars) Cash $ 1,080 Accounts payable $...
Balance Sheet as of December 31, 2018 (Thousands of Dollars) Cash $ 1,080 Accounts payable $ 4,320 Receivables 6,480 Accruals 2,880 Inventories 9,000 Line of credit 0    Total current assets $16,560 Notes payable 2,100 Net fixed assets 12,600    Total current liabilities $ 9,300 Mortgage bonds 3,500 Common stock 3,500 Retained earnings 12,860    Total assets $29,160    Total liabilities and equity $29,160 Income Statement for January 1 - December 31, 2018 (Thousands of Dollars) Sales $36,000 Operating costs 32,440    Earnings before interest...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT