Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Why Ending Cash Balance of April is $104,370? Could you please show how to calculate to get $104,370? Thank you so much. Overall Cash Budget

Why Ending Cash Balance of April is $104,370? Could you please show how to calculate to get $104,370? Thank you so much.

image text in transcribed
Overall Cash Budget Overall Cash Budget for the Quarter Ending June 30, 2018 April May June Beginning Cash Balance Quarter $28,000 $104,370 $20,000 $28,000 + Cash Receipts $717,345 $782,340 $1,028,160 = Cash Available $2,527,845 $745,345 $886,710 $1,048,160 $1,934,870 - Cash Payments $640,975 $879,050 $1,001,300 $2,521,325 = Ending Cash Balance Before Financing $104,370 $7,660 $46,860 Minimum Cash Balance Desired $20,000 $20,000 $20,000 Projected Cash Excess (Deficiency) $84,370 $12,340 $26,860 Financing Borrowing SO $12,340 SO $12,340 Principal Repayments $12,340 $12,340 Interest Repayments (1% per month) $123 $123 Total Effects of Financing SO $12,340 -$12,463 $123 Ending Cash Balance $104,370 $20,000 $34,397 $34,397 CCOUNTING TUTORIALS BY CHRIS SEVERSON

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

Modern Advanced Accounting In Canada

Authors: Murray Hilton

6th Edition

0070001537, 978-0070001534

More Books

Students also viewed these Accounting questions

Question

Mortality rate

Answered: 1 week ago

Question

Armed conflicts.

Answered: 1 week ago