Chapter 13 – Financial Statement Analysis
rdennett
Chapter7.xlsxCommunity Foundation
| COMMUNITY FOUNDATION TRUST FUND | |||||
| ACCRUED | |||||
| reference | Account Titles | Debits | Credits | CASH | INTEREST RECEIVABLE |
| bb | 50,500 | bb | 7,500 | ||
| 7-C-1 | 1 | Cash | 22,500 | 22,500 | 7,000 |
| Additions- Investment Earnings- Interest | 15,000 | 205,500 | 7,500 | ||
| Accrued Interest Receivable | 7,000 | 22,500 | 200,000 | ||
| 2,000 | 204,000 | ||||
| 2a | Cash | 205,500 | 204,000 | 48,000 | |
| Additions- Contributions | 205,500 | ||||
| 55,000 | 8,000 | ||||
| 2b | Investment in RST stock | 200,000 | |||
| Cash | 200,000 | ||||
| INVESTMENT IN | INVESTMENT IN | INVESTMENT IN | |||
| 3 | Cash | 22,500 | CORPORATE BONDS | RST STOCK | UVW STOCK |
| Additions- Investment Earnings- Dividends | 22,500 | bb | 750,000 | bb | bb |
| 2,100 | 200,000 | 204,000 | |||
| 4 | Cash | 2,000 | 200,000 | 1,000 | |
| Additions- Investment Earnings- dividends | 2,000 | ||||
| 5 | Cash | 204,000 | 752,100 | - | 203,000 |
| Investment in RST Stock | 200,000 | ||||
| Additions- Net Increase in Investment | 4,000 | ||||
| NET POSITION | ADDITIONS | ADDITIONS - INVESTMENT | |||
| 5b | Investments in UVW Common Stock | 204,000 | (beginning) | CONTRIBUTIONS | EARNINGS - INTEREST |
| Cash | 204,000 | 808,000 | bb | 205,500 | 15,000 |
| 22,500 | |||||
| 6 | Deductions- Scholarship Awards | 48,000 | 7,500 | ||
| Cash | 48,000 | ||||
| 808,000 | 205,500 | 45,000 | |||
| 7 | Accured Interest Receivable | 7,500 | |||
| Additions- Investment Earnings- Interest | 7,500 | ||||
| ADDITIONS - INVESTMENT | ADDITIONS - INVESTMENT | DEDUCTIONS | |||
| 8 | Investment in MNO Company Bonds | 2,100 | EARNINGS - DIVIDENDS | EARNINGS - ∆ FMV | DISTRIBUTIONS TO NFPs |
| Investment in UVW Company Stock | 1,000 | 2,000 | 4,000 | 48,000 | |
| Additions- Net increase in investments | 1,100 | 1,100 | |||
| 2,000 | 5,100 | 48,000 | |||
| dr | cr | ||||
| 1,066,100 | 1,065,600 | ending balance | |||
&16City of Monroe Community Foundation Trust Fund &16
Pension Trust
| POLICE DEPARTMENT PENSION TRUST FUND | ||||||||
| ACCRUED | INVESTMENT IN | |||||||
| reference | Account Titles | Debits | Credits | CASH | INTEREST RECEIVABLE | CORP. BONDS | ||
| bb | 137,000 | bb | 75,000 | bb | 5,300,000 | |||
| 7-C-1 | 1 | Cash | 800,000 | 800,000 | 86,000 | 7,750 | ||
| Additions- Contributions- Plan Members | 400,000 | 212,000 | ||||||
| Additions- Contributions- Employers | 400,000 | 125,000 | ||||||
| 650,000 | ||||||||
| 2 | Cash | 212,000 | 460,700 | 5,307,750 | ||||
| Accrued Interest Receivable | 86,000 | 506,800 | 500,000 | |||||
| Additions- Investment Earnings- Interest | 126,000 | 170,100 | (11,000) | |||||
| 3 | Cash | 125,000 | ||||||
| Additions- Investment Earnings- Dividends | 125,000 | INVESTMENT IN | NET POSITION | |||||
| CORP. STOCK | ACCOUNTS PAYABLE | (beginning) | ||||||
| 4 | investments in Common Stock | 650,000 | bb | 2,790,000 | 27,000 | bb | 8,275,000 | bb |
| Cash | 650,000 | 650,000 | 447,220 | |||||
| 505,000 | 460,700 | |||||||
| 5 | Deductions- Annuity Benefits | 325,400 | 500,000 | |||||
| Deductions- Disability Benefits | 82,020 | 3,250 | 8,275,000 | |||||
| Deductions- Refunds to Terminated Employees | 39,800 | 3,431,750 | 13,520 | |||||
| Accounts Payable and Accrued Expenses | 447,220 | |||||||
| 6 | Accounts Payable and Accrued Expenses | 460,700 | ADDITIONS - MEMBER | ADDITIONS - EMPLOYER | ADDITIONS - INVESTMENT | |||
| Cash | 460,700 | CONTRIBUTIONS | CONTRIBUTIONS | EARNINGS - INTEREST | ||||
| 400,000 | 400,000 | 126,000 | ||||||
| 7a | Cash | 506,800 | ||||||
| Investments in Common Stock | 505,000 | |||||||
| Additions- Investment Earnings- net Increase | 1,800 | |||||||
| 400,000 | 400,000 | 126,000 | ||||||
| 7b | Investments in Common Stock | 500,000 | ||||||
| Cash | 500,000 | |||||||
| ADDITIONS - INVESTMENT | ADDITIONS - INVESTMENT | DEDUCTIONS | ||||||
| 8 | investments in Bonds | 7,750 | EARNINGS - DIVIDENDS | EARNINGS - ∆ FMV | ANNUITY BENEFITS | |||
| Investments in Common Stock | 3,250 | 125,000 | 1,800 | 325,400 | ||||
| Additions- Investment Earnings- Net Increase in FVI | 4,500 | 4,500 | ||||||
| 125,000 | 6,300 | 325,400 | ||||||
| DEDUCTIONS | DEDUCTIONS - REFUNDS TO | |||||||
| DISABILITY BENEFITS | TERMINATED EMPLOYEES | |||||||
| 82,020 | 39,800 | |||||||
| 82,020 | 39,800 | |||||||
| dr | cr | |||||||
| 9,345,820 | 9,345,820 | ending balance | ||||||
| - | ||||||||
&"Arial,Bold"&14City of Monroe - Police Dept. Pension Trust Fund
Closing Entries
| Community Foundation Private Purpose Trust Fund | |||
| Account Title | Debits | Credits | NET POSITION |
| Additions- Invesment Earnings- Interest | 45,000 | ||
| Additions- Investment Earnings- Dividends | 2,000 | 808,000 | Preclosing |
| Additions- Contributions | 205,500 | 209,600 | closing entry |
| Additions- Net Increase in Investments | 5,100 | ||
| Dedutions- Scholarship Awards | 48,000 | 1,017,600 | |
| Net Assets held in trust for Scholarship Benefits | 209,600 | ||
| Police Department Pension Trust Fund | |||
| Account Title | Debits | Credits | NET POSITION |
| Additions- Contributions- Plan members | 400,000 | ||
| Additions- Contributions- Employer | 400,000 | 8,275,000 | Preclosing |
| Additions- Investment Earnings- Inverest | 126,000 | 610,080 | closing entry |
| Additions- Investment Earnings- Dividends | 125,000 | ||
| Additions- Investment Earnings- Net Increase | 6,300 | 8,885,080 | |
| Deductions- Annuity Benefits | 325,400 | ||
| Deductions- Disability Benefits | 82,020 | ||
| Deductions- Refunds to Terminated Employees | 39,800 | ||
| Net Assets Held in Trust for Pensions Benefits | 610,080 | ||
&14City of Monroe &14 FIDUCIARY FUNDS- Closing Entries
stmt Changes Fiduciary Net Ptn
| Police Pension Trust Fund | Private Purpose Trust Fund | |
| Additions | ||
| Contributions: | ||
| Plan Members | $ 400,000 | |
| Employer | 400,000 | |
| Individuals | ||
| Total Contributions | - | 800,000 |
| Investment Income | ||
| Interest | 45,000 | 126,000 |
| Dividends | 2,000 | 125,000 |
| Net Increase in Fair Value of Investments | 5,100 | 6,300 |
| Total Investment Income | 52,100 | 257,300 |
| Total Additions | 52,100 | 1,057,300 |
| Deductions | ||
| Annuity Benefits | 325,400 | |
| Disability Benefits | 82,020 | |
| Refunds to Terminated Employees | 39,800 | |
| Distribution of Scholarships | 48,000 | |
| Total Deductions | 447,220 | 48,000 |
| Change in Net Position | (395,120) | 1,009,300 |
| Net Position, January 1 | ||
| Net Position, December 31 | $ (395,120) | $ 1,009,300 |
&"Times New Roman,Regular"&14City of Monroe Statement of Changes in Fiduciary Net Position Fiduciary-type Funds For the year ended December 31, 2017
Stmt of fiduciary net position
| Police Pensions Trust Fund | Private Purpose Trust Fund | |
| Assets | ||
| Cash | $ 170,100 | $ 55,000 |
| Accrued Interest Receivable | (11,000) | 75,000 |
| Investments at Fair Value: | ||
| Bonds | 5,307,750 | 752,100 |
| Common Stocks | 3,431,750 | 203,000 |
| Total Investments | 8,739,500 | 955,100 |
| Total Assets | 8,898,600 | 1,085,100 |
| Liabilities | ||
| Accounts Payable | 13,520 | |
| Total Liabilities | 13,520 | - |
| Net Position | ||
| Resources Held in Trust for Pension Benefits and Other Purposes | $ 8,275,000 | $ 808,000 |
&"Times New Roman,Regular"&14City of Monroe Statement of Net Position Fiduciary-type Funds As of December 31, 2017
