Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please provide excel formulas a capital budge

please provide Excel formulas A capital budget was built to...

60.1K

Verified Solution

Question

Accounting

please provide Excel formulas
image
image
A capital budget was built to determine the profitability of an apartment complex. The apartment contains 50 units and typically has a 10% vacancy rate. The price of the complex is $2 million and you believe that you can sell the property in 6 years for $2.2 million. Using the information to the left about annual rents, fixed costs, and variable expenses for each year, find the Net Present Value and Internal Rate of Return. 1) Firt calculate the expected annual revenue and costs for each year on rows 15 to 17. 2) Use the revenues and costss to calculate the total (net) cash flow on row 18. 3) When calculating the Net Present Value, use the Total Cash Flow and Cost of Capital Information. Hint: Your total cash flow in Year 0 is the initial investment and should be added to your NPV, not included in the NPV function. 4) When calculating the Internal Rate of Return, use the Total Cash Flow information. This will tell you what the expected annual return is on the investment. Hint: The initial investment should be included in the IRR function. Extra Note: If the NPV is positive and the IRR is greater than the Cost of Capital, the investment should be made

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

Chemistry
1.2K views

For the following reaction,  10.1 grams of  nitrogen gas are allowed to react with  5.97 grams of  oxygen gas . nitrogen(g) +  oxygen(g)   nitrogen monoxide(g) What is the...

Physics
1.2K views

A person with axial hypermetropia has a lens-retina distance of 1.9 cm and the maximum optical...

Physics
1.2K views

Which statement about a moving object is correct A When an object is accelerating the...

Basic Math
1.2K views

Describe and correct the error in finding the quartiles of the given data set 23...

Accounting
1.2K views

for each of the cases below, calculate the amount of the gain or loss ...

Accounting
1.2K views

Questions Requiring Analysis 10-35 (Static) [LO 10-5, 10-6] During your audit...

Accounting
1.2K views

Shahia Company bought a building for $73,000...

Accounting
1.2K views

Changes in corporate leadership can have a significant impact on how the company functions. In...

Accounting
1.2K views

Explain the appropriate field work needed to review high - risk business transactions for cash...

Accounting
1.2K views

Bramble Company reported the following on its income statement: Income before income taxes $700000 Income...

Finance
1.2K views

Dan Branson is a farmer in Abbotsford, British Columbia. A major part of Dans farm...

Finance
1.2K views

Ricardo is a highly resilient individual, and as such, is likely to O be unable...