Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate on Excel. Bottles Inc Cash Budget For the Month of Jan Beginning cash balance $ 30,000 Total Collections from sales 100,600 Total cash available

Calculate on Excel.

Bottles Inc

Cash Budget

For the Month of Jan

Beginning cash balance

$ 30,000

Total Collections from sales

100,600

Total cash available

130,600

Total cash disbursements

110,000

Excess (Deficiency) of cash

20,600

Financing:

Borrowingnote

? ?

Repaymentsnote

(10,000)

Interest

(100)

Total financing

$9,900

Ending cash balance(must be greater than or at least equal to desired amount)

? ?

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

Managing Finance A Socially Responsible Approach

Authors: D. Crowther

1st Edition

0750661011, 978-0750661010

More Books

Students also viewed these Finance questions

Question

Does your message reiterate its main idea?

Answered: 1 week ago