Scribd
Upload
217 views3 pages

Cash Budget Assignment Overview

This document contains a cash budget assignment submitted by four students. It includes a cash budget table with group sales projections, collections from sales, payments to suppliers and other costs, and net cash inflows on a quarterly basis. It also includes tables calculating short term investments, interest earned, and ending cash and short term investment balances. The assignment contains projections of company finances including sales, expenses, cash flows and investments over a one year period on a quarterly basis.

Uploaded by

Raja Asad
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
217 views3 pages

Cash Budget Assignment Overview

This document contains a cash budget assignment submitted by four students. It includes a cash budget table with group sales projections, collections from sales, payments to suppliers and other costs, and net cash inflows on a quarterly basis. It also includes tables calculating short term investments, interest earned, and ending cash and short term investment balances. The assignment contains projections of company finances including sales, expenses, cash flows and investments over a one year period on a quarterly basis.

Uploaded by

Raja Asad
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

FINANCIAL MANAGEMENT

CASH BUDGET ASSIGNMENT

Submitted by;
Abdul Rehman (L1F17BBAM0042)
Raja Asad Iqbal (L1F17BBAM0044)
Mahnoor Fatima (L1F17BBAM0048)
Rabia Javaid (L1F17BBAM0063)
Submitted To;
Ma’am Snobar Javaid
Section
(C)
CASH BUDGET
Q1 Q2 Q3 Q4
Group Sales (PKR 800 850 860 880
‘000)

Part A
COLLECTIONS FROM SALES
From Current Quarter (800*32/90) (850*32/90) (860*32/90) (880*32/90)
(90-58 Days=32Days) 284.44 302.22 305.77 312.88
From Previous Quarter 495 515.55 547.77 554.22
Total Collections 779.44 817.77 853.55 867.11
Represented by (a)

Payment to Suppliers 174.722 176.77 180.888 182.944


Current Quarter
(next qtr. sales*50%*
37/90)
Payment to Suppliers 235.55 250.277 253.222 259.111
Previous Quarter
(Current Qtr.
Sales*50% *53/90)
Wages, taxes and 200 212.5 215 220
others cost
(25%*current sales)
Long term debt interest 85 85 85 85
Capital Expenditures 0 0 0 260
Total payment 695.277 724.55 734.11 1007.056
Represented by (b)

Net cash Inflow 84.16 93.22 119.44 -139.94


(a-b)

Short Term Financial 0 0 0 0


Beginning Cash 100 100 100 100
Balance
Net Cash Inflow 84.16 93.22 119.44 -139.94
(from above table)
Represented as (a)
Income on short term 0.8 1.6497 2.598 3.818
Represented by (b)
New short term 84.9667 94.8719 122.043 -136.125
(c=a+b)
Beginning Short term 80 164.966 259.838 381.881
Investments
Represented by (d)
Ending Short Term 164.9667 259.83 381.88 245.755
Investments (c+d)

Part B
Beginning Cash 125 125 125 125
Balance
Net Cash Inflow (a) 84.16667 93.22222222 119.4444 -139.944
Net Cash Inflow (b) 0.55 1.397166667 2.343361 3.561239
New Short-Term 84.71 94.619 121.78 -136.382
Investment (a+b)
Ending Cash balance 125 125 125 125
Minimum Cash balance 125 125 125 125
Beginning Short term 55 139.716 234.3361 356.123
Investments
Ending Short Term 139.716 234.336 256.123 219.74
Investments

You might also like