Instructions This exercise is two-part in nature: 1) Using the attached data, which represents five years of actual results of a publicly traded company, please create a dynamic financial model. The...

1 answer below »

View more »
Answered Same DayOct 30, 2021

Answer To: Instructions This exercise is two-part in nature: 1) Using the attached data, which represents five...

Tanmoy answered on Oct 31 2021
120 Votes
Instructions
    This exercise is two-part in nature:
1) Using the attached data, which represents five years of actual results of a publicly traded company, please create a
dynamic financial model. The financial model should include a P&L, Balance Sheet, and Cash Flow statement for Years 1 through 5, as well as project out Years 6 through 8. The financial model should allow for dynamic adjustment of business case assumptions.
2) Based upon your analysis, what insights can you derive about the business? Please include a summary of meaningful business metrics and a brief narrative illustrating your thoughts and findings.
Data
        $ 000's        Actuals
                Year 1    Year 2    Year 3    Year 4    Year 5
        Product Revenue        $ 1,344    $ 1,280    $ 1,280    $ 1,346    $ 1,370
        Service Revenue        $ - 0    $ 123    $ 137    $ 169    $ 215
        Total Revenue        1,344    1,402    1,418    1,515    1,585
        Cost of Products Sold        500    433    434    444    462
        Cost of Services Provided        - 0    53    58    77    98
        Cost of Goods Sold        500    486    491    522    560
        SG&A        616    624    640    680    691
        Interest Expense        46    44    48    47    38
        Cash        16
        A/R        66    66    69    70    88
        Inventory        22    22    22    23    29
        Other Current Assets        27    19    62    71    70
        PP&E        457    459    466    463    462
        Accumulated Depreciation        (335)    (338)    (353)    (359)    (361)
        Accounts Payable        61    60    65    65    71
        Accrued Expenses        92    94    87    96    95
        Other Current Liabilities        41    50    63    51    51
        Long Term Debt        743    748    656    657    400
Dynamic Financial Statement
        Profit & Loss Account
        Particulars    Actuals                    Projected
            Year 1    Year 2    Year 3    Year 4    Year 5    Year 6    Year 7    Year 8
        Product Revenue    1344    1280    1280    1346    1370    1363    1355    1348
        Growth Rate        5%    0%    -5%    -2%    -1%    -1%    -1%
        Service Revenue    0    123    137    169    215    248    287    331
        Growth...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30