0% found this document useful (0 votes)
71 views1 page

Kingston Institute Financial Overview

This document contains projected financial ratios for Kingston Educational Institute over the next 10 years. It shows steady growth in net sales, profits, and net worth. Current assets are expected to consistently exceed current liabilities, maintaining a current ratio above 2. Total outside liabilities will decrease as a percentage of net worth each year. Profits after tax are forecasted to increase each year from 5.3% of net sales to over 26% of net sales in 10 years as the institute experiences financial growth and stability.

Uploaded by

dhimanbasu1975
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)
71 views1 page

Kingston Institute Financial Overview

This document contains projected financial ratios for Kingston Educational Institute over the next 10 years. It shows steady growth in net sales, profits, and net worth. Current assets are expected to consistently exceed current liabilities, maintaining a current ratio above 2. Total outside liabilities will decrease as a percentage of net worth each year. Profits after tax are forecasted to increase each year from 5.3% of net sales to over 26% of net sales in 10 years as the institute experiences financial growth and stability.

Uploaded by

dhimanbasu1975
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

KINGSTON EDUCATIONAL INSTITUTE

RATIO ANALYSIS:
0.00 1.00 2.00 3.00 4.00 5.00 6.00 7.00 8.00

FINANCIAL YEAR
Audited Audited Audited Provisional Estimated Projected Projected Projected Projected Projected Projected Projected Projected
12 mths 12 mths 12 mths 12 months 12 months 12 months 12 months 12 months 12 months 12 months 12 months 12 months 12 months
2016-17 2017-18 2018-19 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28 2028-29
NET SALES 912.00 1,208.44 1,184.73 1,490.87 1,639.96 2,119.19 2,331.11 2,564.22 2,820.65 3,102.71 3,412.98 3,754.28 4,129.71

PROFIT BEFORE INTEREST


DEPRECITION & TAX 125.59 165.43 89.58 151.05 174.48 398.81 484.71 635.56 675.86 820.75 1,021.96 1,210.43 1,474.03

DEPRECIATION 147.45 191.12 186.45 174.41 156.97 - - - - - - - -

OTHER INCOME 29.91 50.83 129.02 70.61 76.26 83.88 84.72 85.57 86.43 87.29 88.16 89.05 89.94

INTEREST - - - - - 183.06 162.17 139.09 113.59 85.43 54.31 19.94 -

PROFIT BEFORE TAX 8.05 25.14 32.15 47.25 93.77 299.64 407.27 582.05 648.69 822.61 1,055.81 1,279.54 1,563.96

PROVISION FOR TAX 2.75 5.84 1.31 14.75 28.98 92.59 125.85 179.85 200.45 254.19 326.25 395.38 483.27

PROFIT AFTER TAX 5.30 19.30 30.84 32.50 64.80 207.05 281.42 402.19 448.25 568.43 729.57 884.16 1,080.70

NET CASH ACCURUALS 152.75 210.42 217.29 206.91 221.76 207.05 281.42 402.19 448.25 568.43 729.57 884.16 1,080.70

PAT/NET SALES(%) 0.58% 1.60% 2.60% 2.18% 3.95% 9.77% 12.07% 15.68% 15.89% 18.32% 21.38% 23.55% 26.17%

CURRENT ASSETS 436.28 638.32 777.25 756.05 1,133.36 1,380.07 1,599.18 1,973.30 2,392.25 2,960.99 3,736.28 4,705.83 5,927.27

CURRENT LIABILITIES 521.10 445.92 282.85 191.80 225.36 464.54 622.62 838.03 1,077.71 1,375.16 1,749.13 2,197.16 2,337.90

NET WORKING CAPITAL (84.82) 192.40 494.40 564.25 908.00 915.53 976.56 1,135.27 1,314.54 1,585.83 1,987.14 2,508.68 3,589.38

CURRENT RATIO 0.84 1.43 2.75 3.94 5.03 2.97 2.57 2.35 2.22 2.15 2.14 2.14 2.54

TOTAL OUTSIDE LIABILITIES [TOL] 534.35 481.40 314.83 184.82 2,260.74 2,300.41 2,238.09 2,210.03 2,180.72 2,181.04 2,226.76 2,312.16 2,452.90
( i.e.SHORT TERM & LONG TERM LIABILITIES )

NET WORTH [TNW] 1,309.67 1,790.44 2,158.05 2,190.54 2,895.47 3,102.51 3,383.93 3,786.13 4,234.37 4,802.80 5,532.37 6,416.53 7,497.23

RATIO OF [ TOL/ TNW ] 0.41 0.27 0.15 0.08 0.78 0.74 0.66 0.58 0.52 0.45 0.40 0.36 0.33

LONG TERM FACILITIES - - - - 1,920.38 1,720.87 1,500.47 1,256.99 988.02 690.88 362.63 - -

EQUITY FUND 1,309.67 1,790.44 2,158.05 2,190.54 2,895.47 3,102.51 3,383.93 3,786.13 4,234.37 4,802.80 5,532.37 6,416.53 7,497.23

DEBT EQUITY RATIO - - - - 0.66 0.55 0.44 0.33 0.23 0.14 0.07 - -

You might also like