Question -01: Considering the following construction projects: a. Road project (minimum 250km) b. Small dam c. Water treatment plant d. Airport e. Sea port f. Hospital g. Tunnel h. Shopping mall i. Metro j. Flyover Calculate the depreciation value by using all three methods as detailed in the lecture. Perform economic analysis using MS-Excel. The following data is to be adopted. Also, perform economic analysis on following: Cost=203073, Salvage value 5%, Year of service= 17 years i. Financing ii. Expenses a. Man power (25%-30%) b. Material (30%-35%) iii. Life cycle costiv. Revenues V. MARR, cost-benefit, RoR/IRR, NPVXNFV, payback period Question -01: Considering the following construction projects: a. Road project (minimum 250km) b. Small dam c. Water treatment plant d. Airport e. Sea port f. Hospital g. Tunnel h. Shopping mall i. Metro j. Flyover Calculate the depreciation value by using all three methods as detailed in the lecture. Perform economic analysis using MS-Excel. The following data is to be adopted. Also, perform economic analysis on following: Cost=203073, Salvage value 5%, Year of service= 17 years i. Financing ii. Expenses a. Man power (25%-30%) b. Material (30%-35%) iii. Life cycle costiv. Revenues V. MARR, cost-benefit, RoR/IRR, NPVXNFV, payback period