Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the method my professor taught on how to create worksheets for our start-up companies, what would the values for all the boxes be? If
Using the method my professor taught on how to create worksheets for our start-up companies, what would the values for all the boxes be? If there's additional information required, please let me know and I'll fill it in (not too familiar with cash budgets and worksheets and am currently on a short deadline)
March April June July August May 25,000 20,000 2 20,000 25,000 30,000 September October 45,000 35,000 November December 55,000 50,000 60,000 Net Sales Collections 70% month of sale 20% month follow 10% 2nd month Total Receipts 7 Net Purchases 30% next month sales 11 12 13 14 Payments 70% month of purchase 30% month follow 15 16 Total Disbursements for purchases Worksheet April May June July Aug Sept. Net Sales 10,000 20,000 30,000 15,000 25,000 20,000 Collections: 30% month of sale3,000 8,080 9,000 4,500 7,500 60% month follow- 6,000 12,000 18,000 9,000 15,000 10% 2nd month - 1,000 2,000 3,000 1,500 Total Receipts 22,000 24,500 19,500 Net Purchases 75% next mth. sales 22,500 11,250 18,750 15,000 Payments: 20% month of purch. 4,500 2,250 3,750 3,000 80% month follow 18,000 9.000 15.000 12,000 Total Disbursements for Purch. 20,250 12,750 18,000Step 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