Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help ASAP thank you Magnificent Muffins Inc. requires a minimum cash balance of $800 at the end of each quarter. Complete the cash

I need help ASAP thank you

Magnificent Muffins Inc. requires a minimum cash balance of $800 at the end of each quarter. Complete the cash budget for Magnificent Muffins Inc.

Magnificent Muffins inc.

Cash Budget

For the Year ending December 31, 2020

Q1

Q2

Q3

Q4

Cash (Beginning)

$600

?

?

?

Cash receipts

Cash from Sales

1,300

1,060

1,100

1,850

Collections from Credit Customers

500

1,440

900

2,150

total Cash Available

?

?

?

?

Cash Payments

Inventory Purchases

400

850

360

560

General & Admin. Expense

625

1,150

300

940

Capital Expenditures

875

1,200

700

800

Dividend Payment

100

200

440

200

total Cash Payments

?

?

?

?

Cash excess (deficit)

?

?

?

?

Financing requirements

Loan Borrowings

?

?

?

?

Loan Repayments

?

?

?

?

ending Cash Balance ( $800)

?

?

?

?

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

Artificial Intelligence In Accounting Organisational And Ethical Implications

Authors: Othmar M. Lehner, Carina Knoll

1st Edition

1032055626, 9781032055626

More Books

Students also viewed these Accounting questions

Question

Describe the three most prominent bond rating systems.

Answered: 1 week ago