Closed

monthly Cash Budget (accounting)

Prepare a monthly Cash Budget in tabular form for the months of February, March and April; showing the bank balance at each month's end.

Company Information and Background

The following data is available from the various functional budgets prepared at Congo Limited.

JanuaryFebruaryMarchApril

$'000 $'000 $'000 $'000

CASH SALES 128 84 72 90

Credit Sales 1,140 760 640 800

Purchases for Resale 880 560 520 320

Salaries and Wages 266 280 238 248

Overhead Expense 160 150 160 140

Other information is available as follows:

1.5% of all sales on credit are expected to become bad debts. Receipts from credit customers are due in the month following sale.

[url removed, login to view] goods are bought on credit from suppliers who allow 2½% cash discount for payment in the month following purchase.

[url removed, login to view] and wages are paid in the month in which they are earned.

[url removed, login to view] for overhead expenses are made in the month following the month in which expenses are incurred. The above overhead budget includes $28,000 per month for depreciation.

[url removed, login to view] new vans costing $21,000 each are to be paid for in April.

[url removed, login to view] amounting to $175,000 is to be paid in March.

[url removed, login to view] balance at the bank as at 31st January is expected to be $222,000.

Skills: Accounting, Data Entry, Excel, Finance, Payroll

See more: prepare monthly cash budget, vans costing paid april, cash budget accounting, wages accounting, salaries, january month, information accounting, month january, expense accounting, depreciation accounting, data entry wages, cash data, balance accounting, accounting bank, accounting as, all accounting, taxation, taxation accounting , overhead, monthly, depreciation, cash, budget, accounting taxation, month budget

About the Employer:
( 0 reviews ) Malaysia

Project ID: #2543668

52 freelancers are bidding on average $267 for this job

imranamin

Lets Start

$250 SGD in 1 day
(48 Reviews)
6.0
uhostings

Highly interested and fully capable to deliver quality output , please check inbox for details !

$250 SGD in 0 days
(40 Reviews)
5.6
xazoo

Consider it done, thanks

$250 SGD in 4 days
(56 Reviews)
5.5
zhj11651

Its my pleasure to bid over here. Looking forward for your positive response. Kindly refer to pm please for details.

$250 SGD in 3 days
(46 Reviews)
5.5
javed1705

dear sir please check pm

$250 SGD in 1 day
(63 Reviews)
5.5
waqar21081974

We have required resources and expertise to complete the desired job. Check your inbox for further details.

$250 SGD in 1 day
(28 Reviews)
5.0
Nhcuong

Hi, I can do it! I'm programmer for years and very familiar with VBA for excel automation. What is your excel version? Looking forwards to work with you, Cuong NH

$250 SGD in 5 days
(19 Reviews)
4.8
SaraHailes

UK qualified accountant with over twenty years financial modelling and Excel experience. Please see PMB for further details of bid.

$250 SGD in 1 day
(7 Reviews)
4.6
LUretsky

I am a career accountant with 30 years of accounting experience.

$250 SGD in 1 day
(14 Reviews)
4.7
ruby22

Certified Public Accountant here and I have done similar assignment like you have for a student here and got a perfect score on this. Ready to work in this accounting assignment for you. Check your message inbox. Sin More

$250 SGD in 1 day
(21 Reviews)
4.5
saqibinam5

Hi, Its my pleasure to bid on your task. Being a qualified chartered certified accountant (ACCA UK) i would like to offer my services for the job you have posted as this relates to my core area of competence "accounts More

$250 SGD in 7 days
(14 Reviews)
4.2
EmpUkbased

Consider it already done, thanks

$250 SGD in 0 days
(4 Reviews)
3.7
Naumaan

Please check the details in PM

$250 SGD in 20 days
(6 Reviews)
3.4
LYNK123

Hi there, I'm an experienced tutor for accounting and professional accountant.

$250 SGD in 0 days
(1 Review)
3.4
muhammadandco

Hi Please check the private message.

$250 SGD in 2 days
(4 Reviews)
3.1
peiyeing

I have been handling cash flow for small businesses that I invested in, thus would be delighted to help on this project.

$250 SGD in 1 day
(1 Review)
2.1
jamiebull

Not an accountant but can do this at a reasonable rate.

$250 SGD in 3 days
(1 Review)
2.0
cagupta

Qualified CA from India here. Pls see PM

$250 SGD in 1 day
(1 Review)
1.8
ErikaKing

Chartered accountant, accounting experience in different countries, including USA and Canada. Check pm, please.

$250 SGD in 1 day
(1 Review)
0.4
shafeymohd

HI SIR I AM A CA STUDENT , I HAVE VAST EXP IN ACCOUNTS RELATED WORK , I HAVE DONE NUMEROUS BUDGETED STATEMENT ... IF YOU WANT MY SERVICE , BE ASSURE IT WILL BE DONE.

$250 SGD in 2 days
(0 Reviews)
0.0