Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone help me fill in the blanks to the second photo? The first photo should help solve the second photo. D E MASTER BUDGET
Can someone help me fill in the blanks to the second photo? The first photo should help solve the second photo.
D E MASTER BUDGET PROJECT: CASH BUDGET TEMPLATE ACCT 5362 | Accounting Principles G H Use the following as inputs into the Cash Budget 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 untilatter the end Other cash items: Tax Rate: 30% The beginning cash balance is $5.000 and the company intends to maintain this level of cash (55.000-$6.000) at the end of each quarter of the cash balance exceeds If ending cash is lnsufficient. loans are taken out at the beginning of the quarter in increments of $1,000 bearing a simple interest rate of 1% per month The interest is pald All components of cash COGS (DM. DL. VMOH) and cash SG&A are paid 23 in the quarter incurred purchased and 13 in the following quarter. Depreciation must be Fixed Overhead and Fixed SG&A are paid 100% in the quarter incurred. All Fixed Assets are depreciated over 10 years (40 quarters). However, the new equipment purchased in Q2 2021 was not placed to service by 1231/202. Therefore, no Sales are collected 50% in the quarter of sale and the balance in the following quarter Taxes are paid in the quarter following the quarter incurred Use the template below to prepare the Cash Budget Q1 Q2 Q3 Q4 18 Use the template below to prepare the Cash Budget. 19 20 Cash Budget 2021 21 Beg Cash 22 Collections 23 Disbursements: 24 DM 25 DL 26 VOH 27 FOH 28 VSGA 29 FSGA 30 Capital Purchases 31 Interest Expense 32 Tax Expense 33 Change to Cash Balance 34 Tifd (Toy From Savings 35 Loans borrowed (repaid) 36 37 Ending Cash $5,483 $5,752 $5.772 $5,170 D E MASTER BUDGET PROJECT: CASH BUDGET TEMPLATE ACCT 5362 | Accounting Principles G H Use the following as inputs into the Cash Budget 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 untilatter the end Other cash items: Tax Rate: 30% The beginning cash balance is $5.000 and the company intends to maintain this level of cash (55.000-$6.000) at the end of each quarter of the cash balance exceeds If ending cash is lnsufficient. loans are taken out at the beginning of the quarter in increments of $1,000 bearing a simple interest rate of 1% per month The interest is pald All components of cash COGS (DM. DL. VMOH) and cash SG&A are paid 23 in the quarter incurred purchased and 13 in the following quarter. Depreciation must be Fixed Overhead and Fixed SG&A are paid 100% in the quarter incurred. All Fixed Assets are depreciated over 10 years (40 quarters). However, the new equipment purchased in Q2 2021 was not placed to service by 1231/202. Therefore, no Sales are collected 50% in the quarter of sale and the balance in the following quarter Taxes are paid in the quarter following the quarter incurred Use the template below to prepare the Cash Budget Q1 Q2 Q3 Q4 18 Use the template below to prepare the Cash Budget. 19 20 Cash Budget 2021 21 Beg Cash 22 Collections 23 Disbursements: 24 DM 25 DL 26 VOH 27 FOH 28 VSGA 29 FSGA 30 Capital Purchases 31 Interest Expense 32 Tax Expense 33 Change to Cash Balance 34 Tifd (Toy From Savings 35 Loans borrowed (repaid) 36 37 Ending Cash $5,483 $5,752 $5.772 $5,170 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