Please see the attached for instructions as well as an answer key for a previous assignment. Please do the assignment on a excel spreadsheet with each part of the assignment on a different tab
IA-1 Title Page Individual Assignment One (IA-1): Stratford House Answer Key MacEwan University HSAD 315: Managing Financial Resources &1#&"Calibri"&11&K000000Classification: Protected A IA1 - General Journal General Journal: Sept. 30, 2015 STRATFORD HOUSE EntryDateAccount #Account NameDebitCreditNotes 1 July 1101CASH144,000 402DONATIONS/PLEDGES INCOME144,000 July 1107VEHICLE37,000 402DONATIONS/PLEDGES INCOME37,000 July 1105EQUIP/FURN29,000 402DONATIONS/PLEDGES INCOME29,000Donation received 2 July 1109PRE-PAID RENT21,000 101CASH21,000Pre-paid for 3 months 3 July 2110PRE-PAID INSURANCE6,000 101CASH6,000Pre-paid for 3 months 4 July 4111SUPPLIES3,275Purchase on account - ESS 201ACCOUNTS PAYABLE3,275(Emergency Services Supplies) 5 July 14101CASH6,700 402DONATIONS/PLEDGES INCOME6,700Fundraising event 6 July 16506VEHICLE EXPENSE110 201ACCOUNTS PAYABLE110Gas purchase on account-Exxen 7 July 27102ACCOUNTS RECEIVABLE-FEES6,500 401FEE INCOME6,500Invoiced BC School Board 8 July 30201ACCOUNTS PAYABLE3,275 101CASH3,275Paid ESS in full 9 Aug. 2 506VEHICLE EXPENSE1,850 201ACCOUNTS PAYABLE1,850Repairs on Account-Exxen 10 Aug. 6 102ACCOUNTS RECEIVABLE-FEES7,150 401FEE INCOME7,150BC Hydro presentation invoiced 11 Aug. 11111SUPPLIES3,603 201ACCOUNTS PAYABLE3,603Purchase on account - ESS 12 Aug. 14501WAGES EXPENSE3,160 101CASH3,160Wages paid, 2 staff for 2 weeks 13 Aug. 18102ACCOUNTS RECEIVABLE-FEES19,500 401FEE INCOME19,500City of Vancouver invoiced 14 Aug. 20101CASH5,500 102ACCOUNTS RECEIVABLE-FEES5,500BC School Board invoice payment 15 Aug. 24510TAX EXPENSE5,700 203TAXES PAYABLE5,700Property tax Payable 16 Aug. 27201ACCOUNTS PAYABLE2,950 101CASH2,950Partial payment-ESS 17 Aug. 27201ACCOUNTS PAYABLE1,800 101CASH1,800Partial payment-Exxen 18 Aug. 30503UTILITIES EXPENSE 8,500 101CASH8,500June & July payment in full 19 Aug. 30501WAGES EXPENSE3,476 101CASH3,476Wages paid, 2 staff for 2 weeks 20Sept. 2101CASH7,150 102ACCOUNTS RECEIVABLE-FEES7,150BC Hydro-fees payment 21Sept. 8101CASH8,580 402DONATIONS/PLEDGES INCOME8,580Donations received 22Sept. 11111SUPPLIES2,900 201ACCOUNTS PAYABLE2,900Purchase on account - ESS 23Sept. 16501WAGES EXPENSE3,165 101CASH3,165Wages paid, 2 staff for 2 weeks 24Sept. 16101CASH1,000 102ACCOUNTS RECEIVABLE-FEES1,000BC School board invoice payment 25Sept. 19102ACCOUNTS RECEIVABLE-FEES4,500 401FEE INCOME4,500Invoiced Enacten-presentation 26Sept. 20101CASH10,500 102ACCOUNTS RECEIVABLE-FEES10,500City of Vancouver part payment 27Sept. 22501WAGES EXPENSE348 202WAGES PAYABLE348Terminated staff-wages owed 28Sept. 25104ACCOUNTS RECEIVABLE-GRANTS35,000 403GOVERNMENT GRANT INCOME35,000Grant received 29Sept. 26101CASH7,500 204UNEARNED INCOME7,500City of Surrey-prepaid fees 30Sept.27501WAGES EXPENSE3,160 101CASH3,160Wages paid, 2 staff for 2 weeks 31Sept. 29202WAGES PAYABLE348 101CASH348Terminated staff wages paid &1#&"Calibri"&11&K000000Classification: Protected A IA1 - General Ledger GENERAL LEDGER: Sept. 30, 2015 STRATFORD HOUSE # 101CASH# 102ACCOUNTS RECEIVABLE-FEES Date: 2015SourceDebitCreditDate: 2015SourceDebitCredit July 1J-1144,000July 27J-76,500 July 1J-221,000Aug. 6 J-107,150 July 2J-36,000Aug. 18J-1319,500 July 14J-56,700Aug. 20J-145,500 July 30J-83,275Sept. 2J-207,150 Aug. 14 J-123,160Sept. 16J-241,000 Aug. 20J-145,500Sept. 19J-254,500 Aug. 27J-162,950Sept. 20J-2610,500 Aug. 27J-171,800Total37,65024,150 Aug. 30J-188,500 Aug. 30J-193,476Balance13,500 Sept. 2J-207,150 Sept. 8J-218,580# 104ACCOUNTS RECEIVABLE-GRANTS Sept. 16J-233,165DateSourceDebitCredit Sept. 16J-241,000Sept. 25J-2835,000 Sept. 20J-2610,500 Sept. 26J-297,500Balance35,000 Sept. 27J-303,160 Sept. 29J-31348#105EQUIPMENT/FURNITURE Total190,93056,834DateSourceDebitCredit July 1J-129,000 Balance134,096 Balance29,000 # 110PRE-PAID INSURANCE DateSourceDebitCredit# 107 VEHICLE July 2J-36,000DateSourceDebitCredit July 1J-137,000 Balance6,000 Balance37,000 # 111SUPPLIES # 109PREPAID RENT DateSourceDebitCreditDateSourceDebitCredit July 4J-43,275July 1J-221,000 Aug. 11 J-113,603 Sept. 11J-222,900Balance21,000 Total9,7780 Balance9,778 # 201ACCOUNTS PAYABLE# 202WAGES PAYABLE DateSourceDebitCreditDateSourceDebitCredit July 4J-43,275Sept. 22J-27348 July 16J-6110Sept. 29J-31348 July 30J-83,275Total348348 Aug. 2J-91,850 Aug. 11J-113,603Balance0 Aug. 27J-162,950 Aug. 27J-171,800# 203TAXES PAYABLE Sept. 11J-222,900DateSourceDebitCredit Total8,02511,738Aug. 24J-155,700 Total05,700 Balance3,713 Balance5,700 # 204UNEARNED INCOME DateSourceDebitCredit # 401FEE INCOME Sept. 26J-297,500DateSourceDebitCredit July 27J-76,500 Balance7,500Aug. 6J-107,150 Aug. 18J-1319,500 # 402DONATIONS/PLEDGES INCOMESept. 19J-254,500 DateSourceDebitCreditTotal037,650 July 1J-1144,000 July 1J-137,000Balance37,650 July 1J-129,000 July 14J-56,700#403GOVERNMENT GRANT INCOME Sept. 8J-218,580DateSourceDebitCredit Total0225,280Sept. 25J-2835,000 Balance225,280Balance35,000 # 501WAGES EXPENSE# 506VEHICLE EXPENSE DateSourceDebitCreditDateSourceDebitCredit Aug . 14J-123,160July 16J-6110 Aug. 30J-193,476Aug. 2J-91,850 Sept. 16 J-233,165Total1,9600 Sept. 22J-27348 Sept. 27J-303,160Balance1,960 Total13,3090 Balance13,309# 510TAX EXPENSE DateSourceDebitCredit # 503UTILITIES EXPENSEAug. 24J-155,700 DateSourceDebitCredit Aug. 30J-188,500Balance5,700 Balance8,500 &1#&"Calibri"&11&K000000Classification: Protected A IA1 - Unadj Trial Bal STRATFORD HOUSE Unadjusted Trial Balance As at September 30, 2015 ACCT #ACCOUNTDEBITCREDIT 101Cash134,096 102Accounts Receiveable-Fees13,500 104Accounts Receivable-Grants35,000 105Equipment/Furniture29,000 107Vehicle37,000 109Pre-paid Rent21,000 110Pre-paid Insurance6,000 111Supplies9,778 201Accounts Payable3,713 203Taxes Payable5,700 204Unearned Income7,500 401Fee Income37,650 402Donations/Pledges Income225,280 403Government Grant Income35,000 501Wages Expense13,309 503Utilities Expense8,500 506Vehicle Expense1,960 510Tax Expense5,700 Total314,843314,843 &1#&"Calibri"&11&K000000Classification: Protected A Classification: Protected A Assignment 2A: Stratford House In Assignment 1, transactions for Stratford House were entered into the General Journal, amounts were posted into the general ledger of accounts, and an unadjusted trial balance was prepared. Assignment 2 continues the accounting work for the organization, Stratford House A description of Stratford House , and their chart of accounts, is repeated below. Stratford House is a non-profit organization that operates an emergency shelter for women and their children in Vancouver. Stratford House earns fee income by providing presentations and information sessions on domestic abuse at workplaces, in schools and for other groups. In addition, the organization also receives government grants and generates some fundraising income each year. Stratford House was incorporated with help from a wealthy private citizen and is governed by a volunteer board. The organization started operations on July 1 2015 . Stratford House: Chart of Accounts Assets Income 101 Cash 401 Fee Income 102 Accounts Receivable - Fees 402 Donations/Pledges Income 103 Accounts Receivable - Donations 403 Government Grant Income 104 Accounts Receivable - Grants 105 Equipment/Furniture Expenses 106 Accumulated Depreciation - Equip/Furn 501 Wages Expense 107 Vehicle 502 Rent Expense 108 Accumulated Depreciation - Vehicle 503 Utilities Expense 109 Prepaid Rent 504 Supplies Expense 110 Prepaid Insurance 505 Insurance Expense 111 Supplies 506 Vehicle Expense 507 Depreciation Expense - Equip/Furn. Liabilities 508 Depreciation Expense - Vehicle 201 Accounts Payable 509 Bad Debt Expense 202 Wages Payable 510 Tax Expense 203 Taxes Payable 204 Unearned Income Equity 301 Retained Earnings 302 Withdrawals Stratford House is required to prepare financial statements on September 30 The following information is known on September 30 2015 : Classification: Protected A Adjustment #1 August 31 The value of supplies on hand is $2,444 Adjustment #2 August 31 Stratford House uses the straight-line depreciation method. The vehicle is expected to have a useful life of 8 years, with a residual value of $1,850 . Adjustment #3 August 31 The furniture and equipment is expected to have a useful life of 15 years with no residual value. Adjustment #4 August 31 The three months of prepaid rent expired on August 31 Adjustment #5 August 31 The three months of prepaid insurance expired on August 31 Instructions: Prepare adjusting entries to reflect the above information. Post the adjusting entries to the general ledger. Prepare an adjusted trial balance as at September 30 2015 . In addition, please prepare the following statements for Stratford House : Statement of Comprehensive Income Statement of Changes in Equity Statement of Financial Position Please use excel for all of this work, to assist with accuracy. Prepare these reports and financial statements to an appropriate business standard.