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

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

Answered: 1 week ago