0% found this document useful (0 votes)
14 views11 pages

Project Cost and Financial Projections

The report outlines the projected costs and financials for a new small-scale trading business, with a total project cost of 5.58 Lac and a loan application of 5.25 Lac. It includes detailed projections for profit and loss, cash flow, and loan amortization over five years, indicating expected growth in gross sales and net profit. Disclaimers emphasize that the projections are estimates and not guarantees of future performance.

Uploaded by

anilk016082
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
14 views11 pages

Project Cost and Financial Projections

The report outlines the projected costs and financials for a new small-scale trading business, with a total project cost of 5.58 Lac and a loan application of 5.25 Lac. It includes detailed projections for profit and loss, cash flow, and loan amortization over five years, indicating expected growth in gross sales and net profit. Disclaimers emphasize that the projections are estimates and not guarantees of future performance.

Uploaded by

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

E TAXWAY SERVICES LIMITED

DEMO

BRIEF REPORT ON PROJECT COST

client name

client address

Disclaimer:

This is declared that the estimates and Projections are incorporated in the Projection report on the basis
of information provided by the promoter.
The amount of revenue and expenses mentioned in Projected Profit and Loss and Projected Balance
Sheet are only the projection and estimations and shall not be interpreted as future guarantee and
viability.
Hence our signature and stamp should not be interpreted as guarantee of future viability of the said
business.
client name

PROJECT AT A GLANCE
[Link]. PARTICULARS

1 Name of the Proprietor client name

2 ConstitutION Proprietorship

3 Address client address


0

4 Object To start new business

5 Size of Unit Small Scale

6 Category Trading

7 Cost of Project 5.58 Lac

8 Promoters Contribution Including L.T.L. 0.33 Lac

9 Loan applied For :


Term Loan 5.25 lac

Disclaimer:
This is declared that the estimates and Projections are incorporated in the Projection report on the basis of information
provided by the promoter.
The amount of revenue and expenses mentioned in Projected Profit and Loss and Projected Balance Sheet are only the
projection and estimations and shall not be interpreted as future guarantee and viability.
Hence our signature and stamp should not be interpreted as guarantee of future viability of the said business.
client name
DEMO

COST OF PROJECT & MEANS OF FINANCE

(Rs In Lakhs)
COST OF PROJECT AMOUNT

FIXED ASSETS AS PER QUOTATION 325,000.00


OTHERS 166,800.00
GOODS AS PER QUOTATION 65,700.00
TOTAL 557,500.00

MEANS OF FINANCE

PROPRIETOR CONTRIBUTION 32,500.00


TERM LOAN 525,000.00
TOTAL 557,500.00
client name

Details of cost of Project

PARTICULARS AMOUNT
Goods as per Quotation 65,700.00
other assets as per quotation
Fixed Assets as per Quotation
working capital as per quotation 325,000.00
Others 166,800.00
TOTAL ( A) 557,500.00
client name

PROJECTED PROFIT AND LOSS ACCOUNT


OPERATING STATEMENT

PARTICULARS 2023-24 2024-25 2025-26 2026-27 2027-28


GROSS SALES 1,865,900.00 2,052,490.00 2,257,739.00 2,483,512.90 2,731,864.19
LESS : COGS 1,082,222.00 1,190,444.20 1,309,488.62 1,440,437.48 1,584,481.23
GROSS RECEIPTS 783,678.00 862,045.80 948,250.38 1,043,075.42 1,147,382.96

EXPENSES
SALARY AND WAGES 120,000.00 132,000.00 145,200.00 159,720.00 175,692.00
REPAIR AND MAINTANENCE 56,900.00 62,590.00 68,849.00 75,733.90 83,307.29
ELECTRICITY EXPENSES 21,400.00 23,540.00 25,894.00 28,483.40 31,331.74
TELEPHONE EXP. 9,690.00 10,659.00 11,724.90 12,897.39 14,187.13
CONVEYANCE EXPENSES 32,450.00 35,695.00 39,264.50 43,190.95 47,510.05
PETROL AND FUEL 10,850.00 11,935.00 13,128.50 14,441.35 15,885.49
TEA AND REFRESHMENTS 12,400.00 13,640.00 15,004.00 16,504.40 18,154.84
OTHER EXPENSES 17,210.00 18,931.00 20,824.10 22,906.51 25,197.16
TOTAL (B) 280,900.00 308,990.00 339,889.00 373,877.90 411,265.69

SURPLUS (A-B) 502,778.00 553,055.80 608,361.38 669,197.52 736,117.27


client name

FINANCIAL INDICATORS
PARTICULARS 2023-24 2024-25 2025-26 2026-27 2027-28

SURPLUS 502,778.00 553,055.80 608,361.38 669,197.52 736,117.27

EXPENSES
INTEREST ON BANK LOAN - - 33,811.34 25,047.14 20,569.57

TOTAL EXPENSES - - 33,811.34 25,047.14 20,569.57

NET PROFIT BEFORE DEP. 502,778.00 553,055.80 574,550.04 644,150.38 715,547.70


LESS DEPRECIATION 25,020.00 21,267.00 18,076.95 15,365.41 13,060.60

SURPLUS BEFORE TAX 477,758.00 531,788.80 556,473.09 628,784.97 702,487.10

INCOME TAX ON SURPLUS 1,589.44 2,823.65 6,439.25 10,124.36

SURPLUS AFTER TAX 477,758.00 530,199.36 553,649.43 622,345.73 692,362.75

CASH SURPLUS 477,758.00 530,199.36 553,649.43 622,345.73 692,362.75

FUNDS AVAIL FOR REPAYMENT 502,778.00 551,466.36 605,537.73 662,758.27 725,992.91


PRINCIPAL REPAYMENT - - 96,208.66 104,972.86 228,635.43

TOTAL BANK INTEREST - - 33,811.34 25,047.14 20,569.57

BANK INSTALMENTS+INTT - - 130,020.00 130,020.00 249,205.00

DEBT SERVICE RATIO #DIV/0! #DIV/0! 4.66 5.10 2.91


(INSTALMENTS ONLY)
AVERAGE
client name

Annexure-1
Depreciation Chart of Assets:
Year Opening WDV Purchase Sale Total Dep @15% Cl. Bal.
2023 166,800.00 - - 166,800.00 25,020.00 141,780.00
2024 141,780.00 - - 141,780.00 21,267.00 120,513.00
2025 120,513.00 - - 120,513.00 18,076.95 102,436.05
2026 102,436.05 - - 102,436.05 15,365.41 87,070.64
2027 87,070.64 - - 87,070.64 13,060.60 74,010.05
client name

PROJECTED CASH FLOW STATEMENT

PARTICULARS 2023-24 2024-25 2025-26 2026-27 2027-28

SOURCES OF CASH
OWNER CAPITAL 32,500.00 - - -
TERM LOAN 525,000.00 - - - -
GOVT. SUBSIDY
CASH FROM OPERATIONS 477,758.00 531,788.80 556,473.09 628,784.97 702,487.10
(BEFORE DEP.)

TOTAL 1,035,258.00 531,788.80 556,473.09 628,784.97 702,487.10

APPLICATION OF CASH
BANK INTEREST - - 33,811.34 25,047.14 20,569.57

REPAYMENT OF LOAN - - 96,208.66 104,972.86 228,635.43

INCREASE IN CASH/BANK 1,035,258.00 531,788.80 426,453.09 498,764.97 453,282.10

TOTAL 1,035,258.00 531,788.80 556,473.09 628,784.97 702,487.10

SUMMARY OF PRINCIPAL & INSTALLMENTS

BALANCE AS ON
YEAR 2023-24 2024-25 2025-26 2026-27 2027-28

O/S LOAN AT BEG. 525,000.00 525,000.00 525,000.00 428,791.34 323,818.48

PAYMENT TOWARDS THE LOAN - - 96,208.66 104,972.86 228,635.43

INTEREST - - 33,811.34 25,047.14 20,569.57


client name

Loan Amortization Table


© [Link]
Loan Principle Amount 525,000.00
Annual Interest Rate 8.75%
Loan Period (in months) 60.00
Original Repayment Amount 10,835.00
Loan Start Date 1-Mar-2022
Repayment Type Beginning

Repayment Opening Loan Interest Capital Closing


Month Number Balance Repayment Charged Repaid Balance
Mar-2022 1 525,000.00 10,835.00 3,828.13 7,006.88 517,993.13
-
Apr-2022 2 517,993.13 10,835.00 3,777.03 7,057.97 510,935.16
May-2022 3 510,935.16 10,835.00 3,725.57 7,109.43 503,825.73
Jun-2022 4 503,825.73 10,835.00 3,673.73 7,161.27 496,664.46
Jul-2022 5 496,664.46 10,835.00 3,621.51 7,213.49 489,450.97
Aug-2022 6 489,450.97 10,835.00 3,568.91 7,266.09 482,184.88
Sep-2022 7 482,184.88 10,835.00 3,515.93 7,319.07 474,865.81
Oct-2022 8 474,865.81 10,835.00 3,462.56 7,372.44 467,493.38
Nov-2022 9 467,493.38 10,835.00 3,408.81 7,426.19 460,067.18
Dec-2022 10 460,067.18 10,835.00 3,354.66 7,480.34 452,586.84
Jan-2023 11 452,586.84 10,835.00 3,300.11 7,534.89 445,051.95
Feb-2023 12 445,051.95 10,835.00 3,245.17 7,589.83 437,462.12
Mar-2023 13 437,462.12 10,835.00 3,189.83 7,645.17 429,816.95
-
Apr-2023 14 429,816.95 10,835.00 3,134.08 7,700.92 422,116.03
May-2023 15 422,116.03 10,835.00 3,077.93 7,757.07 414,358.96
Jun-2023 16 414,358.96 10,835.00 3,021.37 7,813.63 406,545.33
Jul-2023 17 406,545.33 10,835.00 2,964.39 7,870.61 398,674.72
Aug-2023 18 398,674.72 10,835.00 2,907.00 7,928.00 390,746.72
Sep-2023 19 390,746.72 10,835.00 2,849.19 7,985.81 382,760.92
Oct-2023 20 382,760.92 10,835.00 2,790.97 8,044.03 374,716.88
Nov-2023 21 374,716.88 10,835.00 2,732.31 8,102.69 366,614.19
Dec-2023 22 366,614.19 10,835.00 2,673.23 8,161.77 358,452.42
Jan-2024 23 358,452.42 10,835.00 2,613.72 8,221.28 350,231.14
Feb-2024 24 350,231.14 10,835.00 2,553.77 8,281.23 341,949.91
Mar-2024 25 341,949.91 10,835.00 2,493.38 8,341.62 333,608.29
-
Apr-2024 26 333,608.29 10,835.00 2,432.56 8,402.44 325,205.85
May-2024 27 325,205.85 10,835.00 2,371.29 8,463.71 316,742.15
Jun-2024 28 316,742.15 10,835.00 2,309.58 8,525.42 308,216.72
Jul-2024 29 308,216.72 10,835.00 2,247.41 8,587.59 299,629.14
Aug-2024 30 299,629.14 10,835.00 2,184.80 8,650.20 290,978.93
Sep-2024 31 290,978.93 10,835.00 2,121.72 8,713.28 282,265.65
Oct-2024 32 282,265.65 10,835.00 2,058.19 8,776.81 273,488.84
Nov-2024 33 273,488.84 10,835.00 1,994.19 8,840.81 264,648.03
Dec-2024 34 264,648.03 10,835.00 1,929.73 8,905.27 255,742.76
Jan-2025 35 255,742.76 10,835.00 1,864.79 8,970.21 246,772.55
Feb-2025 36 246,772.55 10,835.00 1,799.38 9,035.62 237,736.93
Mar-2025 37 237,736.93 10,835.00 1,733.50 9,101.50 228,635.43
-
Apr-2025 38 228,635.43 10,835.00 1,667.13 9,167.87 219,467.56
May-2025 39 219,467.56 10,835.00 1,600.28 9,234.72 210,232.85
Jun-2025 40 210,232.85 10,835.00 1,532.95 9,302.05 200,930.79
Jul-2025 41 200,930.79 10,835.00 1,465.12 9,369.88 191,560.91
Aug-2025 42 191,560.91 10,835.00 1,396.80 9,438.20 182,122.71
Sep-2025 43 182,122.71 10,835.00 1,327.98 9,507.02 172,615.69
Oct-2025 44 172,615.69 10,835.00 1,258.66 9,576.34 163,039.35
Nov-2025 45 163,039.35 10,835.00 1,188.83 9,646.17 153,393.18
Dec-2025 46 153,393.18 10,835.00 1,118.49 9,716.51 143,676.67
Jan-2026 47 143,676.67 10,835.00 1,047.64 9,787.36 133,889.31
Feb-2026 48 133,889.31 10,835.00 976.28 9,858.72 124,030.59
Mar-2026 49 124,030.59 10,835.00 904.39 9,930.61 114,099.98
-
Apr-2026 50 114,099.98 10,835.00 831.98 10,003.02 104,096.95
May-2026 51 104,096.95 10,835.00 759.04 10,075.96 94,020.99
Jun-2026 52 94,020.99 10,835.00 685.57 10,149.43 83,871.56
Jul-2026 53 83,871.56 10,835.00 611.56 10,223.44 73,648.13
Aug-2026 54 73,648.13 10,835.00 537.02 10,297.98 63,350.15
Sep-2026 55 63,350.15 10,835.00 461.93 10,373.07 52,977.07
Oct-2026 56 52,977.07 10,835.00 386.29 10,448.71 42,528.37
Nov-2026 57 42,528.37 10,835.00 310.10 10,524.90 32,003.47
Dec-2026 58 32,003.47 10,835.00 233.36 10,601.64 21,401.83
Jan-2027 59 21,401.83 10,835.00 156.05 10,678.95 10,722.88
Feb-2027 60 10,722.88 10,835.00 112.12 10,722.88 -
client name

PROJECTED BALANCE SHEET ACCOUNT


Particulars 2023-24 2024-25 2025-26 2026-27 2027-28
LIABILITIES
Capital ( inc. R & S) 493,766.87 631,424.05 786,566.06 960,031.72 1,265,015.53
Loan & Liability 525,000.00 525,000.00 428,791.34 323,818.48 -
Trade payable 14,570.00 16,027.00 17,629.70 19,392.67 23,271.20
-
Total (A) 1,033,336.87 1,172,451.05 1,232,987.10 1,303,242.87 1,288,286.73

ASSETS
Plant and Machinery 141,780.00 120,513.00 102,436.05 87,070.64 74,010.05
Live Stock 325,000.00 341,250.00 358,312.50 376,228.13 395,039.53
Closing Stock 276,800.00 304,480.00 334,928.00 368,420.80 405,262.88
Other Assets 46,970.00 51,667.00 56,833.70 62,517.07 68,768.78
Trade Receivables 147,800.00 162,580.00 178,838.00 196,721.80 216,393.98
Cash & Bank 87,980.00 96,778.00 106,455.80 117,101.38 128,811.52

Total (B) 1,026,330.00 1,077,268.00 1,137,804.05 1,208,059.82 1,288,286.73

Disclaimer:

This is declared that the estimates and Projections are incorporated in the Projection report on the basis of information provided by the promoter
The amount of revenue and expenses mentioned in Projected Profit and Loss and Projected Balance Sheet are only the projection and estimations
and shall not be interpreted as future guarantee and viability.
Hence our signature and stamp should not be interpreted as guarantee of future viability of the said business.

You might also like