Question: If possible complete the solution in Microsoft excel sheet PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's

If possible complete the solution in Microsoft excel sheet

If possible complete the solution in Microsoft excel sheet PROTECTED VIEW Be

PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X V fx A B H K 1.) Dunder Mifflin Paper Company has hired you as a consultant to help prepare the cash budget for the quarter ending June 30th, 2022 and answer a few questions. Michael Scott tells you that: Beginning cash balance April 1st is $74,000. Green Company has an advertising contract of $200,000 per month. Green Company pays $18,000 each month for rent, $7,000 for utilities and $106,000 for salaries. Green Company pays sales commissions to its sales staff of 4% of sales, above their regular salaries. Green Company will pay a yearly $15,000 dividend in the month of April. Green will purchase $16,000 of equipment in May and $40,000 in June. Green must maintain a minimum cash balance of $50,000 each month. All borrowing is done at the beginning of the month, and any repayments are made at the end of the month. The interest rate on borrowings is 10% per year, and interest accrues monthly. Interest must be paid when borrowings are repaid. 2.) Michael Scott asks you which schedule of the master budget is the most important? (Explain using maximum 3 sentences). 3.) Michael Scott asks you what two types of work of managers use budgeting? Explain with an example of each. (Maximum 4 sentences). Assignment 3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!