FNCE6012 Financial Modeling – G5
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
FNCE6012 Financial Modeling – G5
FNCE6012 Individual Assignment 1 (20% of Total Assessment Grade)
• All assignments due are to be handed-in via softcopy submission, latest by the start of class. Late submission will be penalized.
• Softcopy of assignments are to be dropped into SMU eLearn Dropbox using the filename format as <Yourname>_A1.xlsx where A1 refers to Assignment 1. The work should look professional.
• Excel worksheets must include documentation: formulas of important cells and user instructions (if any) .
• Individual Work Policy: This is an individual work, students are expected to produce solutions strictly on your own. You should not consult or discuss the assigned problems with others, and also not refer to each other’s work. Violation of this
policy will be deemed as cheating.
• Assignment due on 17th September.
TOPIC: Financial Projections and Firm Valuation
You are the Group CFO of KSH Holdings Limited, a well-established Construction, Property Development and Property Investment group that was incorporated in 1979 and has been listed on the Mainboard of the SGX-ST since 8 February 2007.
Through strategic alliances and joint ventures, KSH’s property development and investment presence spans across various real estate sectors including residential, commercial, hospitality,and mixed-use developments. Apart from having successfully executed residential and mixed-use development projects in Singapore and the People’s Republic of China (the “PRC”), the Group has jointly acquired properties in other geographies including the United Kingdom, Australia, Malaysia and Japan. It will continue to explore opportunities in new geographies with favourable real estate cycles with a focus on Southeast Asia. On the Property Investment front, the Group invests in yield-accretive assets that generate a sustainable stream of income with potential capital gains. These include a 36-Storey retail and office complex, Tianjin Tianxing Riverfront Square, in the heart of the business district of Tianjin, the PRC.
Improper management of financial and cash flows is often the cause of the collapse of a company, more so than any other factor. As the CFO of the Group, you want to ensure the company liquidity and financial positions are at its best so as to maximise shareholder values and to ensure optimal firm valuation. Therefore, to better manage and anticipate future needs, one key task on hand is to project the Group’s next 5 years financial and cash flow positions.
To-do:
1. Analyse the Company’s annual reports to provide a short write-up of the company’s historical performance and future expectation. (max 1000 words)
2. Project the next 5 years Income Statement and Balance Sheets. What would be the performance ratios for the next five years? Pls ensure that all assumptions and methods are clearly indicated and justified by adding aremark column. (Hint: Not all projections are linear)
3. Given the key Industries the Group is in, what are the concerns you have as a CFO that will impact the Income Statement and Balance Sheets? What type of Sensitivity Analysis will you do? Justify and explain the variables used in your sensitivity analysis.
4. Construct at least two Sensitivity Analysis mentioned in Q3 and provide a short analysis of the results.
5. The value of a firm can be inferred from its financial statement, by determining the net present value (NPV) of all its future Free Cash Flow (FCF). The cash flow of a firm is the stream of cash that will be generated by the firm from its revenue less all the necessary cost, interest, and tax expenses. FCF is based on this same cash flow and add back all non-cash expenses, changes in working capital and capital expenditures.
Estimate the Firm Valuation as of today using the FCF approach.
2023-09-18