Question: Esercise 2 0 - 1 7 ( Algo ) Preparation of cash budgets ( for three periods ) LO P 2 4 2 3 prots

Esercise 20-17(Algo) Preparation of cash budgets (for three periods) LO P2
423
prots
4howe.
Kayak Company budgeted the following cash aecelpts (eacluding cagh recelpos from loann necelvecf) and canh poymeria (excluding eath paymenta for loan princigal and interent paymenta] for the fint theee monthi of neal yese.
Kavak requares a minimum cash halance of $30000 at each monch-end Lows thipen 59 meve mis nequirement charge ths, inserest per morth, paid at each mortberd. The inberets is compubed based on me begirnisg bulance of the loan for the month. Aty prellainaty canh bolance above $70,000 in used to repary loars at morth-end. The compary has a cavh balance of $70,000 and a loan balance of 50.000 at Janyary 1.
Note: Kergative balances and Lean repapmert amoumts pf anpl shewid be indicaled with minus sign.
12
Exercise 20-17(Algo) Preparation of cash budgets (for three periods) LO P2
74.25
q,
atbon n thenow
Kayak Comparyy budgeted the following canh receipts fescluding cash receipts foes ioans received) and cash paymenta (excluding cash payments for loas pericipal and inoevest paymental for the fros thee months of next yede.
\table[[,Cans,Relelyts,Cavs,peytesti],[3ewary,1,524,060,5,66,350],[Itaruary,,418,70.0,,352,170],[Na/cis,,431,4*4,,515,4**]] month. paid at each month end. The interect is computed based on the beginning balasce of the loan lor the movel. Avy prellminary 500,000 at Jatuary 1.
frepare monthly eanh budgets for Jan ang. February, and Murch.
Note: Nepative halances and tean repariment amounts (ff aipl should be indicabed with mivat wign.
\table[[*AvEKCOEMAN],[Cawh Butyet],[,Jowny,Patruay,Wurh],[Repreiry enh baver,1,30.000,8,30, axe,],[Mae Cum woint,,Sth so0,,409 mog,44000
Esercise 2 0 - 1 7 ( Algo ) Preparation of cash

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!