Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Several assumptions need to be reflected in the cash budget. Revenues are estimate to be $30,000 per month; it is estimated that 40% of the

image text in transcribed
Several assumptions need to be reflected in the cash budget. Revenues are estimate to be $30,000 per month; it is estimated that 40% of the customers would pay immediately while 60% would pay up between 30 and 60 days. Their COGS is estimated to be $11,000 per month and the accountant suggested that 50% of their COGS should be paid at the time of purchase with the remaining 50% delayed until the next month. Salaries at $9,000 per month, Lease Costs of $1,200 per month, Utilities of $300 per month, Office Supplies of $100 per month and Advertising of $200 per month need to be accounted for and paid out in each month. Federal Tax installments of $4,000 in March and $5,000 in June also need to be recorded. Q1: Assuming that CompuTech will begin operations with a Cash Balance of $10,500 on January 1, 2021 please complete a Cash Budget for the Martins to share with their accountant. Q2: What impact on the Cash Budget would an increase in COGS were to increase by 30% due to product sourcing problems arising from the pandemic? Further it is estimated that customers may delay their payments resulting in only 20% paying immediately with the remaining 80% carrying over until the second month as AR. What would the Martins have to plan for if the above issues unfolded

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Parimutuel Applications In Finance New Markets For New Risks

Authors: Ken Baron, Jeffrey Lange

1st Edition

1403939500, 9781403939500

More Books

Students also viewed these Finance questions

Question

Calculate a utility estimate for a target organization

Answered: 1 week ago