A B Portfolio Project C D E G H You are the accountants for Wildcat Pizza...

Transcribed Image Text:

A B Portfolio Project C D E G H You are the accountants for Wildcat Pizza Inc. a growing pizza company in Massachusetts. You have been presented with the following financial information for Wildcat Pizza and asked to prepare the Statement of Cash Flows for the year ended June 30, 2024. You will complete all work for the project in this excel file, which includes the following tabs: 1. Facts-Information taken from Wildcat Pizza's accounting records and additional information regarding the cash flows as of June 30, 2024. 2. Worksheet -Worksheet template. 13. Cash Flows -Statement of Cash Flows. 2 3 4 5 16 17 18 Cash 19 Accounts Receivable 20 Marketable Securities (at cost) 21 Allowance for Change in Value 22 Construction in Process 23 Prepaid Expenses 24 Investments (long-term) 25 Leased Equipment 26 Building 27 Deferred tax asset 28 Land 29 Totals Account Balances June 30, 2023 June 30, 2024 Debits $ 397,520 $ 1,128,203 110,000 162,500 11,700 24,700 1,500 2,800 185,625 526,500 49,500 13,000 17,550 26,000 33,000 5,913 2,860 13,650 13,650 808,408 1,917,763 30 31 32 33 Credits 34 Allowance for doubtful accounts $ 6,600 $ 35 Accounts Payable 96,250 5,850 273,000 36 Deferred tax liability 1,100 4,290 37 Income Taxes Payable 3,850 11,700 38 Note Payable (long-term) 3,500 39 Accumulated Depreciation on Building 2,750 40 Accumulated Depreciation on Leased Asset 3,900 41 Lease obligation 23,400 42 Interest payable on lease obligation 2,340 43 Bonds payable 60,000 44 Premium on bonds payable 1,140 45 Billings on contruction in process 165,000 422,500 46 Pension liability 165,000 520,000 47 Convertible preferred stock, $100 par 9,000 48 Common Stock, $10 par 16,000 26,500 49 Additional Paid-in Capital 8,700 50 13,700 Unrealized Increase in Value of Marketable Securities 1,500 51 Retained Earnings 2,800 329,158 52 546,643 Totals 808,408 53 1,917,763 54 55 Additional informations A B Portfolio Project C D E G H You are the accountants for Wildcat Pizza Inc. a growing pizza company in Massachusetts. You have been presented with the following financial information for Wildcat Pizza and asked to prepare the Statement of Cash Flows for the year ended June 30, 2024. You will complete all work for the project in this excel file, which includes the following tabs: 1. Facts-Information taken from Wildcat Pizza's accounting records and additional information regarding the cash flows as of June 30, 2024. 2. Worksheet -Worksheet template. 13. Cash Flows -Statement of Cash Flows. 2 3 4 5 16 17 18 Cash 19 Accounts Receivable 20 Marketable Securities (at cost) 21 Allowance for Change in Value 22 Construction in Process 23 Prepaid Expenses 24 Investments (long-term) 25 Leased Equipment 26 Building 27 Deferred tax asset 28 Land 29 Totals Account Balances June 30, 2023 June 30, 2024 Debits $ 397,520 $ 1,128,203 110,000 162,500 11,700 24,700 1,500 2,800 185,625 526,500 49,500 13,000 17,550 26,000 33,000 5,913 2,860 13,650 13,650 808,408 1,917,763 30 31 32 33 Credits 34 Allowance for doubtful accounts $ 6,600 $ 35 Accounts Payable 96,250 5,850 273,000 36 Deferred tax liability 1,100 4,290 37 Income Taxes Payable 3,850 11,700 38 Note Payable (long-term) 3,500 39 Accumulated Depreciation on Building 2,750 40 Accumulated Depreciation on Leased Asset 3,900 41 Lease obligation 23,400 42 Interest payable on lease obligation 2,340 43 Bonds payable 60,000 44 Premium on bonds payable 1,140 45 Billings on contruction in process 165,000 422,500 46 Pension liability 165,000 520,000 47 Convertible preferred stock, $100 par 9,000 48 Common Stock, $10 par 16,000 26,500 49 Additional Paid-in Capital 8,700 50 13,700 Unrealized Increase in Value of Marketable Securities 1,500 51 Retained Earnings 2,800 329,158 52 546,643 Totals 808,408 53 1,917,763 54 55 Additional informations