Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is all the information provided, please work with what is in the document. Capital Budget: Equipment costing $300,000 will be purchased at the end
This is all the information provided, please work with what is in the document.
Capital Budget: Equipment costing $300,000 will be purchased at the end of Q2, paid in cash. The equipment will not be placed into service for purposes of depreciation until after the end of the year due to installation and Other cash items: Tax Rate: 30% The beginning cash balance is $5,000 and the company intends to maintain this level of cash ($5,000 56,000) at the end of each quarter. If the authbalance exceeds 56,000, the surplus in moved to 1 Lending his insufficient, loans are taken out at the beginning of the quarter in increments of $1.000 bearing simple interest rate of 1% per month The test is paid in the game followinny 2 All components of cuth COGS (DM, DL VMOH) and cash SG&A ure paid 23 in the quarter incurred purchased and 1/3 in the followinquarter. Derection must be subtracted from the COGS 10 13 Foed Overhead ind Fid SGR are paid 100% in the quarter incurred Aloed Assets are depreciated over 10 years (40 quarters). However, the new cuipment purchased in 02 2021 was not placed in service by 12/12/2021. Therefore, no depreciation was recorded on the 15 See collected in the garter of lead the balance in the following quarter 15 Times are paid in the cater following the quarter moured 12 Use the template below to prepare the Cash Badget. 19 20 Cash Budget 2021 02 03 04 21 Bee Cash 22 Collection 23 Disbursements 24 DM 25 DL 26 VON 27 FOH IN VSOA 29 VSGA 10 Carral Purchase 1 Interest Expense Tax Expo 1 Change to Cash 4 Tefdroom Saving 1 Laborwerpad) 01 55,40 22 3.72 19 40 Capital Budget: Equipment conting 5300,000 will be purchased at the end of 2. paid in cash. The equipment will not be placed into service for purposes of depreciation until after the end of the year due to installation and Other cash items: Tax Rate: 30% The bevinnin canh balance is $5,000 and the company intends to maintain this Inel of cash ($5,000-56,000) at the end of each quartier. Il the cash balance exceeds 56,000, the surplus in moved to If endis cash is insufficient, loans are taken out at the besinning of the quarter in increments of $1,000 bearing a simple interest rate of 1% per month. The interest is paid in the quarter followinny All components of coal COGS OM DL VMOH) and cub SG&A at paid 2/3 the quarter incurred parchaland 13 in the following user Dention is besabercted from the COS 10 Fisa Overhand and Fire SG Arad 10% in the quarter incurred All Fixed Assets are depreciated over 10 years (40 garters) However, the new equipment purchased in Q2 2021 wm no placed in service by 17912001. Therefore, no depreciation was recorded on De Sales are collected in the quarter of cale and the balance in the following user Times Cid in the outer following the quarter incurred Use the template below to prepare the Cash Budget 01 02 03 04 Cash Budget 2021 Beg Cash Collections Dabursements 1 DM 5 DI VOH 7 POH VSGA 0 PSGA Capital Purchase 1 Interest Expense Tex Elapse Change to Chance Trid (To Fren Savings Leans borrowed (rpald) 16 37 Ending Coah $5,483 55.252 55.772 55,170 319 Capital Budget: Equipment costing $300,000 will be purchased at the end of Q2, paid in cash. The equipment will not be placed into service for purposes of depreciation until after the end of the year due to installation and Other cash items: Tax Rate: 30% The beginning cash balance is $5,000 and the company intends to maintain this level of cash ($5,000 56,000) at the end of each quarter. If the authbalance exceeds 56,000, the surplus in moved to 1 Lending his insufficient, loans are taken out at the beginning of the quarter in increments of $1.000 bearing simple interest rate of 1% per month The test is paid in the game followinny 2 All components of cuth COGS (DM, DL VMOH) and cash SG&A ure paid 23 in the quarter incurred purchased and 1/3 in the followinquarter. Derection must be subtracted from the COGS 10 13 Foed Overhead ind Fid SGR are paid 100% in the quarter incurred Aloed Assets are depreciated over 10 years (40 quarters). However, the new cuipment purchased in 02 2021 was not placed in service by 12/12/2021. Therefore, no depreciation was recorded on the 15 See collected in the garter of lead the balance in the following quarter 15 Times are paid in the cater following the quarter moured 12 Use the template below to prepare the Cash Badget. 19 20 Cash Budget 2021 02 03 04 21 Bee Cash 22 Collection 23 Disbursements 24 DM 25 DL 26 VON 27 FOH IN VSOA 29 VSGA 10 Carral Purchase 1 Interest Expense Tax Expo 1 Change to Cash 4 Tefdroom Saving 1 Laborwerpad) 01 55,40 22 3.72 19 40 Capital Budget: Equipment conting 5300,000 will be purchased at the end of 2. paid in cash. The equipment will not be placed into service for purposes of depreciation until after the end of the year due to installation and Other cash items: Tax Rate: 30% The bevinnin canh balance is $5,000 and the company intends to maintain this Inel of cash ($5,000-56,000) at the end of each quartier. Il the cash balance exceeds 56,000, the surplus in moved to If endis cash is insufficient, loans are taken out at the besinning of the quarter in increments of $1,000 bearing a simple interest rate of 1% per month. The interest is paid in the quarter followinny All components of coal COGS OM DL VMOH) and cub SG&A at paid 2/3 the quarter incurred parchaland 13 in the following user Dention is besabercted from the COS 10 Fisa Overhand and Fire SG Arad 10% in the quarter incurred All Fixed Assets are depreciated over 10 years (40 garters) However, the new equipment purchased in Q2 2021 wm no placed in service by 17912001. Therefore, no depreciation was recorded on De Sales are collected in the quarter of cale and the balance in the following user Times Cid in the outer following the quarter incurred Use the template below to prepare the Cash Budget 01 02 03 04 Cash Budget 2021 Beg Cash Collections Dabursements 1 DM 5 DI VOH 7 POH VSGA 0 PSGA Capital Purchase 1 Interest Expense Tex Elapse Change to Chance Trid (To Fren Savings Leans borrowed (rpald) 16 37 Ending Coah $5,483 55.252 55.772 55,170 319 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started