AutoSave . OFF 1 Course Budget Project Template v.1 Fall 2022 Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments ab, Calibri (Body) v 11 AA Custom Conditional Formatting Insert O Format as Table x Delete v Paste BIUV Editing Analyze Sensitivity 27 v $ ~ % " Cell Styles Format Data K14 X V fix D G H K M N 0 P Q R S 1 See instructions and additional information required at the bottom of the page (starting on line 22) ACTUAL BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET W NI Dec 20XX Jan 20XX Feb 20xX Mar 20XX Apr 20XX May 20XX Jun 20XX Jul 20XX Aug 20XX Sep 20XX Oct 20XX Nov 20XX Dec 20XX 4 Existing Capital Assets 5 Machinery & Equipment 500,000 500,000 500,000 500,000 500,000 500,000 500,00 500,000 500,000 500,000 500,000 500,000 500,00 6 Building's 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 7 Vehicles 300,000 300,000 300,000 300,00 300,000 300,000 300,000 300,000 300,000 300,000 300,000 300,000 300,000 Total 2,300,000 2,300,000 2,300,000 2,300,000 2,300,000 2,300,000 2,300,000 2,300,000 2,300,000 2,300,000 2,300,000 2,300,000 2,300,000 9 10 Capital Purchases 11 Machinery & Equipment 250,000 300,000 12 Buildings 13 Vehicles 75,000 75,000 14 Other 15 Total Capital Purchases 250,000 75,000 300,000 75,000 16 17 Depreciation Expense Existing 10,833 10,833 10,833 10,833 10,833 10,833 10,833 10,833 10,833 10,833 10,833 10,833 EER'OT 18 Additional Expense on Purchases 2,083 2,708 2,708 5,208 5.208 5,208 5,833 5,833 5,833 5,833 19 Total Depreciation Expense 10,833 10,833 10,833 12,916 13,541 13,541 16,041 16,041 16,041 16,666 16,666 16,666 16,66 Instructions Above is a schedule of fixed or long-term assets (i.e., assets used in the production of goods or services] ines 5- 7 are pulled from the and simply carried forward. Lines 11-14 is where you will budget new capital purchases. We as ll finance all capital purchases by adding to our long-term debt on the Balance She discussing capital equipment needs, your team has told you that they need additional machinery & equipment as well as vehicles to increase sales. Please complete the following: 1). Budget $250,000 for (cell D11] for a new CNC la the machine 2). Budget $300,000 for new welding stations, equipment, and hood in June 3). Budget for the purchase of two new delivery trucks at $75,000 each in March and September 4). In the yellow box below, describe why we would need to budget for capital assets like this. J. What is the effect of capital pur e Statement, and Cash Flows? 61 In the sallow boy bal capitalascate 25 Commentary 26 Use the yellow box below to answer the questions (4 and 5) asked below. Comp. 1 Income Stmt A Comp. 1a Sales&Production Budget COGS A Comp. 2 Balance Sheet A Comp. 2.a Capital Purchases A Comp. 3 Cash Flows + Ready x Accessibility: Investigate + 90%