Scribd
Upload
17 views15 pages

Case Study 1.

The document outlines a financial overview for a business starting from February 1, 2025, detailing cash inflows and outflows across several months. It includes sales data from customers, costs associated with raw materials, fixed costs, and hiring costs, culminating in a net cash flow and closing balance. The document also provides insights into customer orders, pricing, and payment terms.

Uploaded by

سید بلاول شاہ
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
17 views15 pages

Case Study 1.

The document outlines a financial overview for a business starting from February 1, 2025, detailing cash inflows and outflows across several months. It includes sales data from customers, costs associated with raw materials, fixed costs, and hiring costs, culminating in a net cash flow and closing balance. The document also provides insights into customer orders, pricing, and payment terms.

Uploaded by

سید بلاول شاہ
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Starting Date 1-Feb-25

Opening balance ### ###

Sales Column1 Feb Mar


Customer A 200
Customer B
Customer C 100

Cash Inflow Column1 Feb Mar

Revenue from Customer A ### ###


Revenue from customer B Rs - ###
Revenue from customer C Rs - ###
Total Cash In ### ###

Cash Outflow Column1 Feb Mar


Raw Materials
Customer A ###
Customer B Rs -
Customer C ###
Total Raw Material ###
Fixed Costs
Payroll ### ###
Operational ### ###
Financing (Loan) ### ###
Total Fixed Costs ### ###
Hiring Costs
Total Cash Outflow ### ###
Net CashFlow ### ###
Closing Balance ### ###
### ### ### ###

Apr May Jun Jul


150 150
100 100 50
200 150 100

Apr May Jun Jul Total

### ### ### ### ###


### ### ### ### ###
### ### ### Rs - ###
### ### ### ### ###

Apr May Jun Jul Total

Rs - ### Rs - ### ###


### Rs - ### ### ###
### ### ### Rs - ###
### ### ### ### ###

### ### ### ### $90,000,000.00


### ### ### ### ###
### ### ### ### $11,250,000.00
### ### ### ### ###
Rs 500,000.00 Rs 500,000.00 $ 1,000,000.00
### ### ### ### ###
### ### ### ### ###
### ### ### ### ###
Infra Gla

Total Cash Outflow Montly


Rs 400,000,000.00

Rs 350,000,000.00

Rs 300,000,000.00
Da
Rs 250,000,000.00 Co
Co
Co
Rs 200,000,000.00
Co
Co
Rs 150,000,000.00

Rs 100,000,000.00

Rs 50,000,000.00

Rs -
Cash Outflow Total Cash Outflow

600000000 Rs 550,000,000.00

Rs 475,000,000.00
500000000

400000000
Price

300000000 Rs 250,000,000.00
Da
Co
200000000

100000000

500 250 550


0
Customer Customer A Customer B Customer C

Customers
Infra Glance Electronics (Performance Dashboard)

Total Cash Inflow Monthly


Rs 600,000,000.00

Rs 525,500,000.00

Rs 500,000,000.00

Rs 437,000,0
Data Rs 407,000,000.00
Column C Rs 400,000,000.00 Rs 3
Column D
Column E
Column F
Column G Rs 300,000,000.00

Rs 200,000,000.00

Rs 100,000,000.00 Rs 90,000,000.00

h Outflow

Rs -
Cash Inflow Total Cash In
Rs 550,000,000.00

Deliveries each month


1
0.9
0.8
0.7
Data 0.6
Column C 0.5
0.4
0.3
0.2
0.1
550 0
Customer A Customer B Customer C
Customer C
hboard)

w Monthly

Rs 525,500,000.00

Rs 437,000,000.00
Rs 407,000,000.00
Rs 376,500,000.00 Data
Column C
Column D
Column E
Column F
Column G
Rs 221,500,000.00

s 90,000,000.00

Total Cash In

month

Data

Customer C
Customer Column1 Feb Mar Apr
Customer A 200
Customer B 100
Customer C 100 200

Raw Material TypeVendor Price/unit

Mechincal Parts Rs 450,000.00


Rubber & others. Rs 200,000.00
Electronics Parts X Rs 300,000.00
Electronics Parts Y Rs 350,000.00

Term of Payment Column1 Column2 Adv. PercentagePOD


Unit Price For A Rs 1,500,000.00 30% 70.0%
Unit Price For B Rs 1,600,000.00 20% 80.0%
Unit Price For C Rs 1,650,000.00 100.0%

Advan Payments Column1 Column2 Column3 Column4


Customer A Rs 450,000.00 Rs 1,050,000.00
Customer B Rs 320,000.00 Rs 1,280,000.00
Customer C Rs - Rs 1,650,000.00
May Jun Jul Total Units Price/unit Total Cost
150 150 500 ### ###
100 50 250 ### ###
150 100 550 ### ###

Lead Time of receivables after raisin


20
15
7
Data
Cash Outflow Sum of Feb Sum of Mar Sum of Apr Sum of May
Total Cash Outflow Rs 51,875,000.00 Rs 341,875,000.00 Rs 351,875,000.00 Rs 344,875,000.00
Total Result Rs 51,875,000.00 Rs 341,875,000.00 Rs 351,875,000.00 Rs 344,875,000.00
Total Cash Out Montly
Rs 400,000,000.00

Rs 350,000,000.00

Rs 300,000,000.00

Rs 250,000,000.00

Rs 200,000,000.00

Rs 150,000,000.00

Rs 100,000,000.00

Rs 50,000,000.00

Rs -
Cash Outflow Total Cash Outflow
Sum of Jun Sum of Jul
Rs 251,875,000.00 Rs 244,875,000.00
Rs 251,875,000.00 Rs 244,875,000.00

Data
Column C
Column D
Column E
Column F
Column G

Total Cash Outflow


Data
Cash Inflow Sum of Feb Sum of Mar Sum of Apr Sum of May
Total Cash In Rs 90,000,000.00 Rs 407,000,000.00 Rs 525,500,000.00 Rs 437,000,000.00
Total Result Rs 90,000,000.00 Rs 407,000,000.00 Rs 525,500,000.00 Rs 437,000,000.00
Rs 600,000,000.00

Rs 500,000,000.00

Rs 400,000,000.00
Data
Column C
Rs 300,000,000.00 Column D
Column E
Column F
Column G
Rs 200,000,000.00

Rs 100,000,000.00

Rs -
Cash Inflow Total Cash In
Sum of Jun Sum of Jul
Rs 376,500,000.00 Rs 221,500,000.00
Rs 376,500,000.00 Rs 221,500,000.00

Data
Column C
Column D
Column E
Column F
Column G
Sales Data
Customer A Deliveries each month
Feburery1
Marc 0.9 200
April
0.8
May. 150
0.7
June
July 0.6 150 Data
Customer B 0.5
0.4
Feburery
March 0.3
April 0.2 100
May. 0.1
June 0 100
July Customer A
50 Customer B Customer C
Customer C
Feburery
Marc 100
April 200
May. 150
June 100
July
Data
Data
600000000 Rs 550,000,000.00
Customer Units Ordered Total Cost RM
Customer A 500 Rs 475,000,000.00 Rs 475,000,000.00
500000000
Customer B 250 Rs 250,000,000.00
Customer C 550 Rs 550,000,000.00 400000000
Total Result 1300 ###

Price
300000000 Rs 250,000,000.00
Data
Colum
200000000

100000000
500 250 550
0
Customer Customer A Customer B Customer C
Customers
Rs 550,000,000.00

00,000.00
Data
Column C

550

rB Customer C

You might also like