Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can any one help me ? how they calculate principal amount 36952? show the calculation. 3) Cash Budget for next year Particulars A Opening Cash

can any one help me ? how they calculate principal amount 36952? show the calculation. image text in transcribed
3) Cash Budget for next year Particulars A Opening Cash Balance Receipts B Collection of Cash from Customers (Refer 1-a) Quarter Quarter II Quarter III Quarter IV Total S10.000 $12.000 $48.000 S10,000 S261,000 5359,000 S457.000 S295,000 $1,372.000 S271,000 $371,000SSOS,000 $305.000 $1.452.000 Total Available Cash before payment crembursement of expenses (A+B) Payments Cash Payment for Merchandise (Refer 1-b) Selling and Administrative Expenses (refer 2) Dividend Payment for Land Purchases D Total Cash Payments / Expenses S174,000 $234,000 S75.000 590.000 S10.000 $10,000 SO $75.000 $259,000 $409,000 $293.200 SIOS.000 S10.000 $48.000 S456,200 $161.800 $60,000 S10,000 SO $231.800 S863.000 S330,000 $40.000 S123,000 $1.356.000 Surplus/(Shortage) of Cash after payment of E cash expenses (C-D) $12,000 -538.000 $48.800 $73,200 S96.000 F Borrowing from Bank in multiple of S1,000 to maintain minimum required Cash Balance GMinimum Required Cash Balance Available Cash Balance after keeping Minimum Hrequired cash balance SO S10,000 $48.000 $10.000 SO S10,000 S10,000 $2.000 $38.000 538 800 $63,200 Less: Repayment of Borrowing including interest 1 to Bank (Note 1) SO SO S38.800 S11.876 J Closing Cash Balance (G+H-I) S12.000 $48.000 S10,000 $61.324 $61324 Note 1 - Calculation of Interest Re-payment of borrowing in Quarter III -- Principal Amount -- Interest on Borrowing 2.5% per quarter for 2 que Total Re-Payment of Borrowing including interest $36,952 S1.848 $38,800 Re-payment of borrowing in Quarter IV -- Principal Amount Balance (48,000 $36.952) S11,048 -- Interest on Borrowing @ 2.5% per quarter for 3 quarter 5829 Total Re-Payment of Borrowing including interest S11,876

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

Accountants Guide To Fraud Detection And Control

Authors: Howard R. Davia, Patrick C. Coggins, John C. Wideman, Joseph T. Kastantin

2nd Edition

0471353787, 9780471353782

More Books

Students also viewed these Accounting questions

Question

Calculate. (2, 1) + (3, 4)

Answered: 1 week ago

Question

Please help me evaluate this integral. 8 2 2 v - v

Answered: 1 week ago