Answered step by step
Verified Expert Solution
Link Copied!

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!

image text in transcribed 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microeconomics

Authors: Glenn Hubbard, Anthony O'Brien

7th Edition

0134737504, 978-0134737508

More Books

Students also viewed these Finance questions

Question

What are the purposes of promotion ?

Answered: 1 week ago