Scribd Logo
Upload

Welcome to Scribd!

  • 7 views

    FSA Workings

    Uploaded by

    sandggreatstarnigltd

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    FSA Workings

    Uploaded by

    sandggreatstarnigltd
    7 views10 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    7 views10 pages

    FSA Workings

    Uploaded by

    sandggreatstarnigltd

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 10

    Dangote Cement

    forecast income statement for the year 2024


    Year 0 Year 1 Ratio (2020)
    2020 Common Size 2024
    Gross Revenue 719,945 100% 799,139
    Less: Cost of Sale -225,744 -31% 247733
    Gross Profit 494,201 69% 551406
    Less expenses
    Admin expenses -32,289 -4% -31965
    Impairment of Fin Asset -3,318 -3,318
    Other Income and fin inc 113,953 16% 113,953
    S & D Expenses -112,919 -16% -127,862
    Net Profit BIT 459,628 64% 502214
    Finance Cost -28,881 -28,881
    Profit before tax 430,747 473333
    Tax -78,138 18% -85,199
    PROFIT AFTER TAX 352,609 388134

    Tax/PBT = 18 18% of 473,333 = -85,199


    DANGOTE CEMENT
    FORECAST STATEMENT OF FIN POSITION

    Current ratio = 1
    TAT = 0.34
    FAT = 0.46

    Remain constant bc it doesn't affect turnover


    Remain constant bc it doesn't affect turnover
    ANGOTE CEMENT
    RECAST STATEMENT OF FIN POSITION FOR THE YEAR 2024

    2020 2023
    CURRENT ASSET 554,048 613150
    NON CURRENT ASSET 1,562,012 1,737,258 Total asset - Non-current asset + current asset
    TOTAL ASSET
    2116069 2,350,408

    CURRENT LIABILITIES 538,613 595,291 Use ratio to get current liabilities


    NON CURRENT LIABILITI 225,070 250856 Total liabilities - current liabilities = Non current liabilities
    TOTAL LIABILITIES 763,683 846,147 Current liabilities + Non current liabilities = Total liabilities
    SHARE HOLDERS FUND 1,504,261 TL PLUS SHF - Total liabilities = Shareholder's fund
    TL PLUS SHF 2,350,408
    + current asset

    s = Non current liabilities


    liabilities = Total liabilities
    = Shareholder's fund
    Working notes
    Sales
    Sept Oct Nov Dec jan Feb mar April
    3 6 6 10.5 10.5 14.5 16
    Oct 3
    Nov 6
    Dec 6
    Jan 10.5
    Frb 10.5
    Mar
    April
    May
    June
    July
    Aug
    Sep

    Collectiofrom debtors 3 6 6 11 11

    Purchases
    Sept Oct Nov Dec jan Feb mar April
    Sales 1 6 6 10.5 10.5 14.5 16
    Purchase 2 4 4 7 7 9.67 10.67
    Cashpmt

    To get cost (purchase) C=sp/1.5


    Where 1.5 os the mark-up cost o 0.5
    and cost i 1
    1.5
    May June July Aug Sep
    18 20 24 26 26 180

    14.5
    16
    18
    20
    24

    14.5 16 18 20 24

    May June July Aug Sep


    18 20 24 26 26
    12 13.3 16 17.3 17.3
    Cash Budget
    Sept Oct Nov Dec jan Feb mar April
    Cash Inflow (Mil naira)
    Cash sales
    collection debtors 3 6 6 10.5 10.5
    Equity 10
    Total Cash Inflow 3 6 6 10.5 20.5

    Cash Outflow
    Inventory Payable (Pur 5 2 4 4 7 7 9.7
    Running expenses 1.6 1.6 1.6 1.6 1.6 1.6 1.6
    Drawings 1 1 1 1 1 1 1
    Fixed Ass Acq 8

    Total Outflow 13 2.6 4.6 6.6 6.6 9.5 9.6 12.3


    Net cash flow -13 -2.6 -4.6 -3.6 -0.6 -3.5 0.9 8.2
    Opening cash balance 15 2 -0.6 -5.2 -8.8 -9.4 -13 -2.1
    Closing Bal 2 -0.6 -5.2 -8.8 -9.4 -13 -2.1 -3.9
    May June July Aug Sep

    14.5 16 18 20 23.5

    14.5 16 18 20 23.5

    10.7 12 13.3 15.7 17.3


    1.6 1.6 1.6 1.6 1.6
    1 1 1 1 1

    13.3 14.6 15.9 18.3 19.9


    1.2 1.4 2.1 1.7 3.6
    -3.9 -2.7 -1.3 0.8 2.5
    -2.7 -1.3 0.8 2.5 6.1
    Work note
    Sales
    March April May June July August
    80,000 84,800 89,888 95,281 100,998
    April 67,840
    May 71,910
    June 76,225
    July 80,799
    August 85,646
    September

    Collectors from debtors 67,840 71,910 76,225 80,799 85,646

    Purchases
    March April May June July August
    Sales 80,000 84,800 89,888 95,281 100,998
    Purchases
    ``
    September October
    107,058 558,025

    90,785

    90,785

    September October
    107,058 558,025

    You might also like