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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!