Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please use excel mr.arnold is considering constru

Please use excel Mr.Arnold is considering constructing a bungalow project that requires an investment...

60.1K

Verified Solution

Question

Accounting

imagePlease use excel

Mr.Arnold is considering constructing a bungalow project that requires an investment of $15,500,000, which comprises $12,000,000 for the building and $3,500,000 for land. The bungalow has 50 rooms. He expect the maintenance cost for the bungalow building to be $350,000 the first year and $400,000 the second year, after which it will continue to increase by $50,000 in subsequent years. The cost to hire a manager for the building is estimated to be $85,000 per year. After five years of operation, the bungalow building can be sold for $17,000,000. a) What is the annual rent per room that will provide a return on investment of 15% after tax? Assume that the bungalow will remain fully occupied during the five years. Assume also that the tax rate is 35%. The bungalow will be depreciated according to 39-year MACRS and will be placed in service in January during the first year of ownership and sold in December during the fifth year of ownership. b) If Mr.Arnold expects to borrow the initial investment ($15,500,000) at 10% over five years (paying back the loan in equal annual payments of $4,088,861), determine the project's net cash flows

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students