Using the attached data, which represents five years of actual results of a publicly traded company,...

Question

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.

capture-2qfirwnh.jpg

Khushboo · Accepted Answer

Financial analysis:
In the case, the entity has earned $182 thousands as net income which shows that entity has earned handsome amount of net income in 1st year of operations itself and has provided handsome amount of return to its shareholders. Further, the asset base of the company is majorly financed from long- term loans as the total assets are $253 thousands which has been entirely financed from debt. During the five years,

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,...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment