Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cash budget: Quarter April May June Total Beginning cash balance $ 74,000 $ 50,000 $ 50,000 $ 174,000 Add cash receipts: Cash collections from sales

Cash budget:
Quarter
April May June Total
Beginning cash balance $ 74,000 $ 50,000 $ 50,000 $ 174,000
Add cash receipts:
Cash collections from sales 436,000 695,000 865,000 1,996,000
Total cash available $ 510,000 $ 745,000 $ 915,000 $ 2,170,000
Less cash disbursements:
Purchases of inventory 258,000 318,000 244,000 820,000
Sales commissions 26,000 40,000 20,000 86,000
Advertising 200,000 200,000 200,000 600,000
Rent 18,000 18,000 18,000 54,000
Salaries 106,000 106,000 106,000 318,000
Utlities 7,000 7,000 7,000 21,000
Equipment 16,000 40,000 56,000
Dividends Paid 15,000 15,000
Total disbursements $ 630,000 $ 705,000 $ 635,000 $ 1,970,000
Cash excess (deficiency) $ (120,000) $ 40,000 $ 280,000 $ 200,000
Financing:
Borrowing 170,000 10,000 - 180,000
Repayment (principal) (180,000) (180,000)
Interest payment (5,300) (5,300)
Total financing 170,000 10,000 (185,300) (5,300)
Ending cash balance $ 50,000 $ 50,000 $ 94,700 $ 194,700
Need help in the below section: 12 Percent Anual Interest Rate.
Calculations for June financing section:
Cash available for repayment 230000
Interest on quarterly borrowing -6900
Interest payment (all or nothing) -6900
Remaining cash available for principal repayment 223100
Remaining cash available rounded down 223100
Total borrowing for April and May 170,000 10,000
Total borrowing for April and May rounded down 170,000 10,000
Principal repayment -180000

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_2

Step: 3

blur-text-image_3

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

Principles Of Financial Modelling Model Design And Best Practices Using Excel And VBA

Authors: Michael Rees

1st Edition

111890401X, 978-1118904015

More Books

Students also viewed these Finance questions

Question

When should you avoid using exhaust brake select all that apply

Answered: 1 week ago