User Account

All Pages

Calculate in excel the npv and irr of this investment

Assignment Help Managerial Accounting
Reference no: EM132959090

Scenario - You've spent $25,000 searching for an investment property. Now, you're considering investing in a cottage near Brighton Beach. You can buy the house for $300,000 with cash, earn $19,090 per year in rent and pay $8,000 per year in HOA, taxes and other expenses. Assume you'll be able to sell the house in ten years for $400,000.

1. Calculate in Excel the NPV (assume you need to earn at least 5%) and IRR of this investment. Is this a good investment?

2. Now, assume that you must spend $100,000 in year 10 to raise the house on stilts due to sea-level rise from a warming planet, What are the NPV and IRR in this scenario? Is the cottage a good investment now?

3. You must submit an Excel worksheet for this assignment. Check your work for completeness, accuracy, spelling, grammar before submitting it.

Reference no: EM132959090

Questions Cloud

Record the transactions in the first year : The fair value of the transaction is 2 000€, the annual lease fee is 375€, the implicit interest rate is 10%. Record the above transactions in the first year
Engineering design plan : Plan a design solution and prepare an engineering design specification in response to a stakeholder's design brief and requirements.
Information and advice about industrial relations : To whom might you provide information and advice about Industrial Relations?
Why local policy makers build politically acceptable surplus : Why local policy makers build a politically acceptable surplus into the budget is? to provide a contingency against revenues falling short of estimates.
Calculate in excel the npv and irr of this investment : You can buy the house for $300,000 with cash, earn $19,090 per year in rent and pay $8,000 per year in HOA, Calculate in Excel NPV and IRR of this investment
Hiring people of different cultures : What might be some challenges that HR might face hiring people of different cultures or more women in the workforce.
Which school districts receive the majority of their funding : Which School districts receive the majority of their funding from? Which is not one of the primary roles of government in shaping economy and society in general
How much is the vat payable of new urban appliance : Purchases, total invoice value 224,000. How much is the VAT payable of New Urban Appliance Corporation for the first quarter of 2021
Successful implementation of hris : Technology alone is not sufficient to ensure a successful implementation of HRIS(human resource information system). What else is necessary?

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Prepare a report showing the spending variances for april

Prepare a report showing the spending variances for April. Explain what these variances mean.

  Make a production budget for the months

Compute the budgeted cash payments, for purchases of direct material, that would appear on the December cash budget. Make a production budget for the months

  Determine the cost of ewip and the cost of the goods

Using the weighted average method, determine the cost of EWIP and the cost of the goods transferred out. If required, round your answers

  What is the difference in profit for each of the products

What is the difference in profit for each of the products if Hommie decides to process further Orapine and Banango instead of selling it at split-off?

  Computer the row percentages for your cross tabulation

What relationship, if any, do you notice between profit and stockholders' equity. Computer the row percentages for your cross tabulation in part (a).

  Prepare the necessary journal entries

Pension Plan In 2017, SaulGroup, Inc. made amendments to its pension plan. Prepare the necessary journal entries

  What is the strategic importance of the corporate governance

What is the strategic importance of the Corporate Governance, discuss any case which lead to the huge loss due to the failure of corporate governance.

  Find what is the net present value of the project

The working capital would be released for use elsewhere when the project is completed. What is the net present value of the project, using a discount rate of 8%

  Calculate ev of launch with product and market test

Calculate EV of launch with product and market test? Calculate EV of launch with product test? Calculate EV of launch without test?

  How would respond to mrs jamison if were in lisa position

If you were in Lisa's position, how would you respond to Mrs. Jamison? Address potential ethical implications and applicable accounting principles

  How journalize the four entries required to close accounts

Rainbow Services Co., How Journalize the four entries required to close the accounts. If an amount box does not require an entry, leave it blank.

  Calculate the amount of differential cost

Wilson also incurred $10,000 of product-level costs to design the racket and $100,000 of facility-level costs. Calculate the amount of differential cost.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd