I need to create an Excel File , Account Cycle Monopoly project

12:55 Done Attachment Purchased Venture $200 Purchased Short Line Rode Purchased Oriental Are 5100 Payment on the company-120 2 Landed on Free Parking SEO Purchased home for Venter 5150 and 52 Purchased 30 Landed to ad5200 5 Purchased house for Oriental 50 and 582 Purchased Park Place 5350 Purchased House for race 5200 and 552 for nurance Purchased house on Pared Purchased Pennsylvania 5220 Purchased Hover Pro 5200 and 10 Received test on Venter 180 Purchased house for rent 200 nothing Landed on Free Parking received $250 Nahanhand is $3,467 a) All tractices occur on Monday of each week. One quarter is 13 weeks. "ush must be reconciled at the end of week 4 and 13. your cash on hand the d of both of these wecks does not equal your casa per books, make entries to 2 of 3 jul your book balance to your actual cu bulines. Greach the overcome c) At the end of the work only pay and record a dividend to your stockholders of 10% of your cash on hand Record ALL entries using proper general joumal format, duted by wecke Adjusting entries MUST include supporting calculation. Remember that you are using ACCRUAL ACCOUNTING and must make adjustments for certain items (Ao remember that justing entries never include an try to cash) Each time you have a transaction that included passing Go, you received se case the bank and be recorded as Niete. Poalle. The boon is a 6 months Interest accrues starting with the work you received the Note: Any interest due on loans will be paid in cash on the first day of the NEXT quarter the quarter following the end of your 13-weck quarter b) Cash.recked another time that .ped.Oshould be recorded as Learned Management et Herman Fees are cred evenly over a 13 week period, starting with the mocksiyos passed and read them. Investing in Property Property Property ownership wally leads to rent revue Landing one's property leads to respection When recording railroader utility practice, the Blancheprise should be split benen Land.20land Estima Houses Note that a house ee a property increases the amount of real revenue yo With these that was prechlaca haradisurance polics was ao purchased. The cost cach polic was 52 free year 152 Depreciation Information Depreciation must be calculated to the nearest werk. In other words, if you buy a house in week and you are recording depreciation for the quartet, you would need works of depreciation (weck 5.6.7.8.9.10,11,12,13). Assume Socks in a year the following information to calculate depreciation And Life Di Mehed Salg of con RR Equip Syr Deuble declining balance 10% of cost Ulty Equip 79 Double declining balance 10% of cost Jall: la transaction was recorded that would have sent you to jail, a 5100 fee was paid to the bank. Record this as "Legal Fee Expense." Free Parking: Inacticelunded you on "Free Parking. 5250 cmh a collected from the bank. Reed this as "Gaison Lawsuit Taxes: During the 13 weergameplay.goog Das Miss Expo Week Transaction 1 Received $3000 as contribution to the corporation Purchased Ventor Ave $260 Purchased Short Line Railroad (RR) $200 Purchased Oriental Ave $100 Pay rent on Electric company--$120 Purchased house for Ventnor $150 and $52 for insurance Landed on Free Parking received $250 2 Purchased house for Ventnor $150 and $52 insurance 3 Purchased B&O RR $200 Landed on go to jail; paid $100 4 Note: cash on hand before dividend $1864 Paid required cash dividend to stockholders Purchased house for Oriental $50 and $52 insurance 5 6 Purchased Park Place $350 Purchased House for Park Place $200 and $52 for insurance Received $650 for passing "GO" the first time Paid $100 for Hospital Fees-(Medical Expense) 7 Received Rent on Ventnor $330 Purchased house on Park Place $200 and $52 insurance 8 Paid rent on Pennsylvania RR $25 2 of 2 rent on Pennsylvania RR $25 9 Purchased Pennsylvania Ave $320 Purchased House for Pennsylvania $200 and $52 for insurance 10 Received rent on Ventnor Ave $330 Received $650 for passing "GO" second time Paid rent on Mediterranean Ave $2 Received rent on Ventnor Ave $330 11 Received rent on Pennsylvania $150 Paid rent on Vermont $6 Purchased house for Pennsylvania $200 and $52 for insurance 12 nothing happened 13 Landed on Free Parking, received $250 Note: cash on hand is $2,467 12:55 Done Attachment Purchased Venture $200 Purchased Short Line Rode Purchased Oriental Are 5100 Payment on the company-120 2 Landed on Free Parking SEO Purchased home for Venter 5150 and 52 Purchased 30 Landed to ad5200 5 Purchased house for Oriental 50 and 582 Purchased Park Place 5350 Purchased House for race 5200 and 552 for nurance Purchased house on Pared Purchased Pennsylvania 5220 Purchased Hover Pro 5200 and 10 Received test on Venter 180 Purchased house for rent 200 nothing Landed on Free Parking received $250 Nahanhand is $3,467 a) All tractices occur on Monday of each week. One quarter is 13 weeks. "ush must be reconciled at the end of week 4 and 13. your cash on hand the d of both of these wecks does not equal your casa per books, make entries to 2 of 3 jul your book balance to your actual cu bulines. Greach the overcome c) At the end of the work only pay and record a dividend to your stockholders of 10% of your cash on hand Record ALL entries using proper general joumal format, duted by wecke Adjusting entries MUST include supporting calculation. Remember that you are using ACCRUAL ACCOUNTING and must make adjustments for certain items (Ao remember that justing entries never include an try to cash) Each time you have a transaction that included passing Go, you received se case the bank and be recorded as Niete. Poalle. The boon is a 6 months Interest accrues starting with the work you received the Note: Any interest due on loans will be paid in cash on the first day of the NEXT quarter the quarter following the end of your 13-weck quarter b) Cash.recked another time that .ped.Oshould be recorded as Learned Management et Herman Fees are cred evenly over a 13 week period, starting with the mocksiyos passed and read them. Investing in Property Property Property ownership wally leads to rent revue Landing one's property leads to respection When recording railroader utility practice, the Blancheprise should be split benen Land.20land Estima Houses Note that a house ee a property increases the amount of real revenue yo With these that was prechlaca haradisurance polics was ao purchased. The cost cach polic was 52 free year 152 Depreciation Information Depreciation must be calculated to the nearest werk. In other words, if you buy a house in week and you are recording depreciation for the quartet, you would need works of depreciation (weck 5.6.7.8.9.10,11,12,13). Assume Socks in a year the following information to calculate depreciation And Life Di Mehed Salg of con RR Equip Syr Deuble declining balance 10% of cost Ulty Equip 79 Double declining balance 10% of cost Jall: la transaction was recorded that would have sent you to jail, a 5100 fee was paid to the bank. Record this as "Legal Fee Expense." Free Parking: Inacticelunded you on "Free Parking. 5250 cmh a collected from the bank. Reed this as "Gaison Lawsuit Taxes: During the 13 weergameplay.goog Das Miss Expo Week Transaction 1 Received $3000 as contribution to the corporation Purchased Ventor Ave $260 Purchased Short Line Railroad (RR) $200 Purchased Oriental Ave $100 Pay rent on Electric company--$120 Purchased house for Ventnor $150 and $52 for insurance Landed on Free Parking received $250 2 Purchased house for Ventnor $150 and $52 insurance 3 Purchased B&O RR $200 Landed on go to jail; paid $100 4 Note: cash on hand before dividend $1864 Paid required cash dividend to stockholders Purchased house for Oriental $50 and $52 insurance 5 6 Purchased Park Place $350 Purchased House for Park Place $200 and $52 for insurance Received $650 for passing "GO" the first time Paid $100 for Hospital Fees-(Medical Expense) 7 Received Rent on Ventnor $330 Purchased house on Park Place $200 and $52 insurance 8 Paid rent on Pennsylvania RR $25 2 of 2 rent on Pennsylvania RR $25 9 Purchased Pennsylvania Ave $320 Purchased House for Pennsylvania $200 and $52 for insurance 10 Received rent on Ventnor Ave $330 Received $650 for passing "GO" second time Paid rent on Mediterranean Ave $2 Received rent on Ventnor Ave $330 11 Received rent on Pennsylvania $150 Paid rent on Vermont $6 Purchased house for Pennsylvania $200 and $52 for insurance 12 nothing happened 13 Landed on Free Parking, received $250 Note: cash on hand is $2,467