Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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,000

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

Advanced Financial Accounting

Authors: Richard Lewis, David Pendrill

6th Edition

0273638335, 978-0273638339

Students also viewed these Accounting questions