Data:

All required data given in the attached Construction Finance-Coursework-Data in Excel sheet. Assuming the current date as AUG 2020, the up to date financial reports (Balance Sheet, Income Statement and Statement of Cash Flow) data are given in Table1, Table2, and Table 3 respectively. The additional transaction data is given in Table 4 Requirements: The students are required to develop a report (not less than 1200-1500 words) along with Excel spreadsheets as an aid in preparing and updating of financial reports. Each student is requested to: 1. Use the given transaction data (Table 4) to update the missed items in the final financial reports and critically discuss the company financial performance trend (use Excel Formulas to do any required calculations and create Excel charts as a helping tool in the analysis of financial trend Horizontal Analysis). 2. Use Excel to prepare the balance sheet , income statement and prepare a tabular analysis which shows the effects of the transactions on the accounting equation . 3. Based on the financial ratios calculations, critically discuss ( any five ) in detail the company financial position and the linkages between the different types of financial report (use Excel Formulas to calculate financial ratios and use Excel charts to support your discussion). Notes: a. A student may be called for VIVA to discuss his work if the instructor have a doubt regarding the source of the work (outsourced). b. Any missing/incorrect data should be reasonably assumed after getting instructor approval. c. A student should use his own data without change otherwise his report will not marked.

Table :

https://drive.google.com/file/d/1nuNLodcrmdtz8NUU4ZfsK6yiZvxew0U_/view?usp=sharing