Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Tools for Business Decision Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso, Barbara Trenholm, Wayne Irvine

6th Canadian edition

1118644948, 978-1118805084, 1118805089, 978-1118644942

Students also viewed these Accounting questions