Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the income statement for this cash budget? City Ltd. Assignment Hjem Sett inn Tegn Sideoppsett Formler Data Se gjennom Visning X Calibri (Brad....

image text in transcribed

What is the income statement for this cash budget?

City Ltd. Assignment Hjem Sett inn Tegn Sideoppsett Formler Data Se gjennom Visning X Calibri (Brad.... 12 A- A- Q Sek i ark 2+ Del . AY Q: Format Sorter Sak att ag filtrar og marke Bryt takst Standard TX Lim in . FK K D.. A + Sl sammen og midtstill . % 900 Slatt Sett inn , Betinget Formater Callastilor formatering sem tabell 033 A B D E F G H K L N 1 E c M Cash Budget 2 2 for the year ended March 31, 2021 3 April May June July August September October November December January February IMarch Year 4 Begginning Cash Balance 13 066 - 271 132 236 138 - 167 114 - 107 780 42 844 209 818 364 522 554 026 796 660 1 002 334 5 Cash Collection from Sales 33 000 E 38 500 E 338 250 E 398 750 E 426 250 E 525 250 E 552 750 E 555 500 E 574 750 594 000 544 500 497 750 5 079 250 6 Cash from issue of Ordinary shares E 140 000 140 000 7 Total Cash Available 173 000 25 434 67 118 E 162 612 259 136 417 470 595 594 765 318 939 272 1 148 026 1 341 160 1 500 084 ES 219 250 8 Less: Cash Disbursements 9 For Purchases f 100 500 E 105 750 E 115 500 143 250 E 150 000 150 750 158 250 163 500 148 500 E 135 000 135 750 1 506 750 10 For Direct Labour 80 400 84600 73 920 91 680 96 000 96 480 101 280 104 640 95040 86 400 86 880 90 240 1 087 560 11 For Manufactoring Overhead 89 983 94 183 E 83 503 E 101 263 E 105 583 E 106 063 E 110 863 E 114 223 104 623 E 104 623 95 983 96 463 E 99 823 E1 202 560 12 For Admin and Distribution Expense 15 683 E 17283 E 18 083 21 283 22 083 22 083 22 883 23 683 22 083 22 083 20 483 20 483 21 283 E 247 400 13 For Purchase of Equipment 22 000 22 000 14 Total Cash Disbursements 186066 E 296 566 E 303 256 E 329 726 E 366 916 E 374 626 E 385 776 E 400 796 E 385 246 351 366 338 826 347 096 E4066 262 15 16 Ending Cash Balance 13 066 - 271 132 - 236 138 -E 167 114 - 107 780 E 42 844 E 209 818 E 364 522 554 026 E 796 660 E1 002 334 1 152 988 E1 152 988 17 18 19 20 21 22 23 24 25 26 27 -E

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions

Question

What is Accounting?

Answered: 1 week ago

Question

Define organisation chart

Answered: 1 week ago

Question

What are the advantages of planning ?

Answered: 1 week ago