80.2K

Verified Solution

Link Copied!

hello i am preparing a one month master budget for university, before the business begins. im currently up to the cash budget, my question is in regards to income taxes, as its the first budgeted month of operation can i put 0 or what would i put there? also in equipment do i include the pre purchased computer that id be claiming depreciation on? or is that just for planned future equipment purchases in the month?

AutoSave . Off ) excelmasterbudget 9 Search (Alt+Q) Mathew Favero MF Close File Home Insert Page Layout Formulas Data Review View Help Comments Share Insert Calibri 11 ~ A A al Wrap Text General Ex AY O Ex Delete Paste BIU V V V A v E Merge & Center $ ~ % 9 08 20 Conditional Format as Cell Sort & Find & Analyze Formatting Table ~ Styles v Format Filter ~ Select Data Clipboard Font IN Alignment Number Styles Cells Editing Analysis J7 X V fix A B C D E F G H J A Koala Rescue Bear Company-Koala Rescue Bear Division W N - Cash Budget For the month ending 31st of March 2022 4 Beginning cash budget 0 Cash sales and collections on account $80,785 6 Total cash available $80,785 less:Disbursements 8 Payments for: Raw materials 6,953 10 Direct Labour 28,618 11 Overhead 10,081 12 Selling and administration expenses 9,050 13 Income taxes 14 Equipment 15 Total Disbursements 16 Excess (deficiency) of cash available over needs 17 Ending cash balance 18 19 20 21 ... Finished goods inventory Cost of goods sold budget Selling Admin Expenses Budget Sheet2 + Ready + 100% O A O W X ~ DOED(.() ENG 1:37 PM Type here to search 99+ 8/03/2022

Answer & Explanation Solved by verified expert

See Answer