Question

In: Accounting

Using the financial statements below,please calculate the following The current position of each company, The market...

Using the financial statements below,please calculate the following

The current position of each company,

The market value of each company,

The amount of profit generated by each dollar of assets or equity,

How much debt is involved in each company compared to equity, and

How solvent each business is.

THE PEOPLES’ CREDIT UNION LIMITED

Financial statements for THE PEOPLES’ CREDIT UNION LIMITD) for the year ended December 31, 2017.

Each share costs $5.00

The dividend paid was 3.75%

December 31, 2017

Cash Resources:

Cash in hand and at bank

11,961,005

Short-term investments

71,000,511

Total cash resources

82,691,516

Other Assets:

Accounts receivable and prepayments

2,738,666

Net loans to members

343,075,646

Long-term investments

71,513,400

Fixed assets

29,202,515

Total Assets

529,221,743

Liabilities:

Accounts payable and accruals

7,800,932

Members’ deposit savings

34,623,468

Members’ time deposits (fixed deposits)

90,629,600

Provision for terminal benefits

5,303,180

Retirement benefit obligations

638,200

Members’ share savings

324,230,903

Total liabilities

463,226,283

Institutional Capital:

Reserve fund

22,992,421

Education fund

1,446,107

Loan protection fund

836,726

Building fund

12,250,000

Investment re-measurement reserve

15,266,397

Undivided earnings

13,203,809

Total institutional capital

65,995,460

Total Liabilities and Institutional Capital

529,221,743

For the year ended December 31 2017

Income:

Interest on loans

37,358,266

Investment income (net)

2,020,571

Other income

1,262,899

Total Income

40,671,736

Expenditure:

Administrative expenses

7,956,429

Board and committees’ expenses

1,072,631

Life saving insurance

866,002

Loan protection expense

1,716,236

Loan loss expense

129,286

Interest on members’ expense

2,170,128

Members education, training and development expenses

1,636,889

Personnel costs

10,635,898

Total expenditure

26,183,499

Net surplus for the year

14,458,237

Other comprehensive income

Items that may be re-classified later as profit or loss

Unrealised (loss)/gain on available-for-sale financial assets

974,380

Items that may be re-classified later as profit or loss

Net actuarial (loss)/gain on retirement benefit obligations

(294,500)

679,880

Total Comprehensive Income for the year

15,138,117

Reserve fund

Education fund

Loan protection fund

Building fund

Investment re-measurement fund

Undivided earnings

Balance as at January 1, 2017

21,523,987

1,170,891

711,676

11,500,000

14,292,017

11,819,316

Total comprehensive income for the year

974,380

14,163,737

Appropriation of net surplus for the year:

10 % to the Reserve Fund

1,416,374

(1,416,374)

13.5% to the Education Fund

1,912,105

(1,912,105)

13% to the Loan Protection Fund

1,841,286

(1,841,286)

22,940,361

3,082,996

2,552,962

11,500,000

15,266,397

20,813,288

Add/(less) adjustments as follows:

Dividends (2016)

(10,160,544)

Entrance fees

52,060

(52,060)

Member education, training and development expenses

(1,636,889)

1,636,889

Transfer to Building Fund

750,000

(750,000)

Loan protection expense

(1,716,236)

1,716,236

Balance as at December 31, 2017

22,992,421

1,446,107

836,726

12,250,000

15,266,397

13,203,809

Solutions

Expert Solution

1. Financial Condition of Company

From equation of accounting

Capital = Assets - liabilities

65,995,460 = 529,221,743 - 463,226,283

65,995,460 = 65,995,460

Accounting equation is satisfied with balance sheet balances. Assets balance is 529221743 which is more than liabilities, so company's financial condition is good fron balance sheet.

From income statement

Company has more income than expenditures. So it generates profits.

On the other hand, company has various reserve funds allocated for reserve fund, education fund, loan protection fund, building fund, Investment Re-measurement Fund, undivided earnings are increased from jan1,2017 to dec31,2017.

Increase in Reserved Fund = 22,992,421 - 21,523,987 = 1468434

Increase in Education Fund = 1,446,107 - 1,170,891 = 275216

Increase in loan Protection Fund = 836,726 - 711,676 = 125050

Increase in Building Fund = 12,250,000 - 11,500,000 = 750000

Increase in Investment Re-measurement Fund = 15,266,397 - 14,292,017 = 974380

increase in undivided earnings = 13,203,809 - 11,819,316 = 1384493

From balance sheet, assets are more than liabilities, From income statement Incomes are more than expenditure, so there is profit generation by company, From fund flow statement company has increase in all categories of funds, so from above data, company's financial condition is good.

2. Market value of company

Total investments = no. of short term investments + no. of long term investments

71,000,511 + 71,513,400 = 142513911

Each share cost $5

no.of shares outstanding = 142513911/5 = 28502782.2 == 28502782

market value = no.of shares outstanding * share price = 142513910

divided paid = 28502782.2 * 3.75 = 106885433.25

3. Profit

profit = income - expenditure

profit = 40,671,736 - 26,183,499 = 14488237

4. Debt Obligations of company

Debt is related with liabilibities and dividends which a company has to pay to its investers. dividends are already paid by organisation shows from above data given.undivided earnings may also have a part of debt.

5. Solvancy condition of company

Solvancy condition is arise when a company has poor financial condition, more liabilities and debt are pending. From above THE PEOPLES’ CREDIT UNION LTD. Company has better financial condition, there is no need of solvancy of company into another.


Related Solutions

Using the following selected items from the comparative statements of financial position of Anders Company, illustrate...
Using the following selected items from the comparative statements of financial position of Anders Company, illustrate horizontal and vertical analysis.                                                                        December 31, 2014               December 31, 2013 Inventory                                            $   1,053,000                             $   780,000 Accounts Receivable                                 900,000                                  600,000 Total Assets                                             4,000,000                               2,500,000
Financial​ ratios: Liquidity. The financial statements for Tyler​ Toys, Inc. are shown below. Calculate the current​...
Financial​ ratios: Liquidity. The financial statements for Tyler​ Toys, Inc. are shown below. Calculate the current​ ratio, quick​ ratio, and cash ratio for Tyler Toys for 2013 and 2014. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the​ shareholders? Tyler Toys, Inc. Income Statement for Years Ending December 31, 2013 and 2014 2014 2013 Revenue $14,147,831 $13,567,868 Cost of goods sold $-8,447,482 $-8,132,539 Selling, general, and administrative expenses...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position Beginning Balance Ending Balance Assets: Cash $ 346,000 $ 324,792 Accounts receivable 202,000 159,000 Inventory 298,000 299,000 Plant and equipment (net) 463,000 455,000 Investment in Cedar Company 318,000 293,000 Land (undeveloped) 237,000 237,000 Total assets $ 1,864,000 $ 1,767,792 Liabilities and owners' equity: Accounts payable $ 249,000 $ 228,000 Long-term debt 855,000 855,000 Owners' equity 760,000 684,792 Total liabilities and owners' equity $ 1,864,000...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position Beginning Balance Ending Balance Assets: Cash $ 295,000 $ 336,524 Accounts receivable 178,000 180,000 Inventory 275,000 222,000 Plant and equipment (net) 480,000 441,000 Investment in Cedar Company 306,000 322,000 Land (undeveloped) 273,000 273,000 Total assets $ 1,807,000 $ 1,774,524 Liabilities and owners' equity: Accounts payable $ 224,000 $ 197,000 Long-term debt 824,000 824,000 Owners' equity 759,000 753,524 Total liabilities and owners' equity $ 1,807,000...
The comparative statements of financial position for 2023 and 2022 are given below for Surmise Company....
The comparative statements of financial position for 2023 and 2022 are given below for Surmise Company. Net profit for 2023 was $50 million. SURMISE COMPANY Comparative Statements of Financial Position December 31, 2023 and 2022 ($ in millions) 2023 2022 Assets Cash $ 36 $ 40 Accounts receivable 92 96 Less: Allowance for uncollectible accounts (12 ) (4 ) Prepaid expenses 8 5 Inventory 145 130 Long-term investment 80 40 Land 100 100 Buildings and equipment 420 300 Less: Accumulated...
Given below are the Statements of Financial Position and the Statement of Profit or Loss for...
Given below are the Statements of Financial Position and the Statement of Profit or Loss for BA107 Trading Bhd: 2020 (RM) Sales 505,000 Cost of sales (105,000) Gross profit 400,000    Expenses   (252,000) Profit before tax 148,000 Taxation (40,000) Profit after tax   108,000 2020 2019 (RM) (RM) Property, plant and equipment 355,000 300,000 Trade receivables 80,000 75,000 Inventory 145,000 120,000 Bank balance   24,500      15,000 604,500    510,000 Ordinary share capital 250,000 250,000 Retained profits 222,500    140,000 472,500 390,000 Other payables 87,000...
Using the financial statements shown below, calculate net operating working capital(NOWC)
                                    Chapter Two -- Spreadsheet Assignment     Using the financial statements shown below, calculate net operating working capital(NOWC), total net operating capital (OC), net operating profit after taxes (NOPAT), operating cash flow (OCF), free cash flow (FCF), and return on invested capital (ROIC).                                      ...
On Len and Joan Miller’s personal statements of financial position shown below, identify whether each account...
On Len and Joan Miller’s personal statements of financial position shown below, identify whether each account is a cash inflow or a cash outflow.                                                     2014                2013         Cash Inflows   Cash Outflows Assets House                                    $205,000        $136,000                Car                                          22,000                6,000              Furniture                                      8,500                7,000              RRSPs                                        30,000              20,000              Savings bonds                              5,000                4,000              Short-term deposits                     2,000              2,000                 Total assets                           $272,500        $175,000 Equity                                  $ 111,000         $...
Using the attached financial statements please calculate for 2017 and 2016: Days in Accounts receivable, Days...
Using the attached financial statements please calculate for 2017 and 2016: Days in Accounts receivable, Days Cash on hand, equity financing percentage, cash flow to debt percentage, times interest earned, fixed asset turnover ratio, current asset turnover ratio, average age of facilities. Please show all work and calculations Balance Sheet Assets 2017 2016 Current Assets Cash and Cash equivalents $82,815 $59,696 Assets limited as to use, current portion 5,327 5,088 Accounts Receivable Patients, less allowance for doubtful accounts ($25,302 in...
The current year financial statements for Blue Water Company and Prime Fish Company are presented below....
The current year financial statements for Blue Water Company and Prime Fish Company are presented below. Blue Water Prime Fish Balance sheet: Cash $ 41,100 $ 20,900 Accounts receivable (net) 38,500 31,300 Inventory 98,500 40,600 Property & equipment (net) 141,500 402,200 Other assets 84,100 306,000 Total assets $ 403,700 $ 801,000 Current liabilities $ 98,500 $ 50,500 Long-term debt (interest rate: 15%) 65,700 60,200 Capital stock ($10 par value) 148,700 513,000 Additional paid-in capital 29,100 106,100 Retained earnings 61,700 71,200...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT