Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, I need help solving the attached problems in Excel. They can only be done in Excel. Please do not claim the lesson before reading
Hi, I need help solving the attached problems in Excel. They can only be done in Excel.
Please do not claim the lesson before reading the problems and you know you can solve them.
Thank you!
MBA - International Hospital and Healthcare Management Autumn 15 PostAssignment - Module 2 Finance 1. On Jan. 1, 2015 you are offered the following conditions for leasing a hospital appliance: initial payment of 10,000$ (due right now) plus additional 36 monthly payments of 3,500$ (due at the end of each month) plus a final payment of 20,000$ (due in 3 years). The lease contract comes without service or maintenance. Calculate the present value of the payments associated with the lease contract assuming an effective annual interest rate of 5%. Would you be better off if you could change the 36 monthly payments into 3 annual payments of 42,000$ (due at the end of each year)? As an alternative, you are offered to buy the appliance at a price of 140,000$ (due immediately). Is it better to buy or to lease the appliance? 2. Irrespective of your results for question 1, assume now you decided to reject the lease offer and rather want to buy the appliance at 140,000$. You have gathered the following additional information: The estimated use is 4 years (with an estimated selling price of 10,000$ after 4 years). The total variable cost per year (wages, material, etc.) are 30,000$. Associated sales revenue is 75,000$ per year. For ease of calculation assume that variable costs as well as revenues are due at the end of each year. Your hospital requires a hurdle rate of 8% for projects like this. Provide 3 appropriate capital budging criteria to evaluate whether the investment is profitable. 3. You are interested in buying a competitor firm nearby. You get the following financial forecasts for this company (in mio $): t = Current Assets Fixed Assets Total Assets 0 400.00 1,000.00 1,400.00 1 420.00 1,050.00 1,470.00 2 441.00 1,102.50 1,543.50 3, 4, 5, ,... 441.00 1,102.50 1,543.50 Current Liabilities Long term Liabilities Equity Total Capital 40.00 400.00 960.00 1,400.00 42.00 437.38 990.62 1,470.00 44.10 508.78 990.62 1,543.50 44.10 508.78 990.62 1,543.50 Sales CoGS Depreciation Interest Taxes Net Income 2,000.00 1,800.00 100.00 16.00 25.20 58.80 2,100.00 1,895.00 100.00 17.50 26.26 61.24 2,205.00 1,989.76 105.00 20.36 26.96 62.92 2,205.00 1,984.50 110.26 20.36 26.96 62.92 a) Calculate the \"Free Cash Flow\" for each year. b) Risk free rates are currently at 2%. Assume a company beta of 1.4 and an equity risk premium of 5%. How large is the WACC? c) What is a fair price to pay for the company? Please send ONE Excel file containing all your calculations and answers per email to Ute Gottschalk (u.gottschalk@fs.de) until Monday, Feb. 8, 2016. Please note: Use separate sheets in your Excelfile to answer the above questions. Make all calculations explicit inside these sheets. Structure your spreadsheets such that the information is easily understandable for a time constrained reader. Label all tables accordingly. Grading is based on both \"content\" and \"appearance\Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started