Question: Two submissions are required: A. Solution to Sensitivity Analysis - Excel file B. Solution to Printed report - PDF file A. Sensitivity Analysis (using a
Two submissions are required: A. Solution to "Sensitivity Analysis" - Excel file B. Solution to "Printed report" - PDF file A. Sensitivity Analysis (using a graph) Your colleagues were asked by MSUFCU to perform an additional sensitivity analysis of Clarck's project starting from the APV model that was completed in the classroom. Below, find more details about the MSUFCU's request. Liquidity Concern The APV model shows that thanks to the tax shield generated by two MSUFCU loans, the project is profitable. However, MSUFCU is concerned that profitability measured using present values may "hide" some potential liquidity issues in some future years. The financial institution would like a detailed analysis of Clarck's project liquidity on an annual basis. MSUFCU's "Liquidity" requirement states that each year, the project's cash flows must be high enough to cover the required interest payments and principal payments (in case of amortized loans) due in that year. In order to assess whether the project meets MSUFCU's liquidity requirement, build (in "Liquidity Analysis") a graph that compares total net financing flows and operating FCFs, on an annual basis, from 2024 to 2038. B. Printed report Print (in PDF) the results of your analysis and all supporting models. The
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
