Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 29 views

    Financial Analysis Assessment Template

    Uploaded by

    shades13579
    practice

    Copyright:

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

    Financial Analysis Assessment Template

    Uploaded by

    shades13579
    29 views4 pages
    practice

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    practice

    Copyright:

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

    Financial Analysis Assessment Template

    Uploaded by

    shades13579
    practice

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 4

    Financial Analysis Course Assessment Solution Strictly Confidential

    Table of Contents

    Financial Statements

    © 2015 to 2023 CFI Education Inc.


    This Excel model is for educational purposes only and should not be used for any other reason. All content is Copyright material of CFI Education Inc.
    All rights reserved. The contents of this publication, including but not limited to all written material, content layout, images, formulas, and code, are protected
    under international copyright and trademark laws. No part of this publication may be modified, manipulated, reproduced, distributed, or transmitted in any
    form by any means, including photocopying, recording, or other electronic or mechanical methods, without prior written permission of the publisher,
    except in the case of certain noncommercial uses permitted by copyright law.

    https://corporatefinanceinstitute.com/
    Income Statement

    All figures in USD millions unless stated Year 1 Year 2 Year 3 Year 4 Year 5

    Revenue 3,288,319 3,979,296 4,401,879 6,256,617 8,110,518 2.405


    COGS (1,472,032) (1,755,910) (1,937,888) (2,648,052) (3,618,178)
    Gross Profit 1,816,287 2,223,386 2,463,991 3,608,565 4,492,340

    SG&A (987,967) (1,172,314) (1,317,212) (2,000,828) (2,571,969)


    Other 9,414 8,254 (35,638) (49,662) (402,322)
    EBITDA 837,734 1,059,326 1,111,141 1,558,075 1,518,049

    Depreciation 1 (122,484) (161,933) (291,791) (224,206) (185,478)


    EBIT 715,250 897,393 819,350 1,333,869 1,332,571

    Interest Expense – – – – –
    Interest Income – – – – –
    EBT 715,250 897,393 819,350 1,333,869 1,332,571

    Provision for Taxes (231,449) (251,797) (230,437) (358,547) (477,771)

    Net Income 483,801 645,596 588,913 975,322 854,800


    Cash Flow Statement

    All figures in USD millions unless stated Year 1 Year 2 Year 3 Year 4 Year 5

    CASH FROM OPERATING


    Net Income 483,801 645,596 588,913 975,322 854,800
    Depreciation 122,484 161,933 291,791 224,206 185,478
    Other non cash adjustments (269,712) (302,902) (378,414) (818,387) 158,295
    Cash From Accounts Receivable (57,895) (4,433) (22,180) (14,602) (55,905)
    Cash From Inventory (21,178) (162,038) (237,249) (366,518) (593,699)
    Cash From Accounts Payable (23,626) 119,941 262,760 522,156 86,864
    Subtotal 233,874 458,097 505,621 522,177 635,833

    CASH FROM INVESTING


    Capital Expenditure (242,794) (278,408) (695,532) (427,891) (569,937)
    Subtotal (242,794) (278,408) (695,532) (427,891) (569,937)

    CASH FROM FINANCING


    Change in Long-Term Debt - - - -
    Change in Common Equity (100,261) 32,496 80,557 15,068 (4,534)
    Dividends - - - -
    Change in Revolving Credit Line - - - -
    Subtotal (100,261) 32,496 80,557 15,068 (4,534)

    CASH BALANCE
    Beginning of the Year 990,501 881,320 1,259,871 1,150,517 1,093,505
    Increase / (Decrease) (109,181) 212,185 (109,354) 109,354 61,362
    End of the Year 881,320 1,093,505 1,150,517 1,259,871 1,154,867
    - - - - -
    Balance Sheet

    All figures in USD millions unless stated Year 1 Year 2 Year 3 Year 4 Year 5

    ASSETS

    Cash 881,320 1,093,505 1,150,517 1,259,871 1,154,867


    Accounts Receivable 35,786 40,219 62,399 77,001 132,906
    Inventories 512,176 674,214 911,463 1,277,981 1,871,680
    Total Current Assets 1,429,282 1,807,938 2,124,379 2,614,853 3,159,453

    Property Plant & Equipment 517,170 764,698 1,317,365 1,530,527 1,481,544

    Total Assets 1,946,452 2,572,636 3,441,744 4,145,380 4,640,997

    LIABILITIES

    Accounts Payable 500,477 620,418 883,178 1,405,334 1,492,198


    Revolving Credit Line – – – – –
    Total Current Liabilities 500,477 620,418 883,178 1,405,334 1,492,198

    Long-Term Debt - - - - -
    Total Liabilities 500,477 620,418 883,178 1,405,334 1,492,198

    EQUITY

    Common Equity 99,085 131,581 212,138 227,206 222,672


    Retained Earnings 1,346,890 1,820,637 2,346,428 2,512,840 2,926,127
    Total Shareholders' Equity 1,445,975 1,952,218 2,558,566 2,740,046 3,148,799

    Total Liabilities & Equity 1,946,452 2,572,636 3,441,744 4,145,380 4,640,997

    Check – – – – –

    You might also like