Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Version A Cash Budget With the following information, prepare a cash budget for the months of January to April 2021 Forecast of sales for the
Version A Cash Budget With the following information, prepare a cash budget for the months of January to April 2021 Forecast of sales for the periods Nov-20 $75,000 Dec-20 590,000 Jan-21 $90,000 Feb-21 $105,000 Mar-21 $130,000 Apr-21 $150,000 The credit manager provides the following information about sales revenue recovery 50% comes in as cash sales today, 30% one month lag, 20% in two months lag Cost of sales (COGS) is assumed to be 50% of revenues. - Spreadsheet set-up to calculate Payment of Outstanding COGS Invoices is as follows 50% paid today and 50% in one month ag Monthly expenses are as follows Salaries $25.000 Leasing Expenses $5,000 Promo & Advertising $3,000 Taxes are paid in each of February and Aoni are $15.000 por payment In February company plans to purchase sets of 545 000. In Apnt another asset purchase of $15.000 The beginning cash balance in the bank on January 16, 2023 517.300 Agent Prepare the Cash Budget a requested Excel
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