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

Q

Consider the following schema: Publisher (name, phone, city), PK: name. Book (ISBN, title, year, published_by, previous_edition, price), PK: ISBN,...

Programming
Q

In Marlon Bailey's essay he identifies 6 specific categories of gender; choose one category and link...

Psychology
Q

When current changes from 2 A to 2 A in 0 05 s an emf...

Physics
Q

8 6 OO 10 6 23 2 6 8 10 y 2 4 161 8...

Geometry
Q

Taxes are used for which of the two major categories relating to income redistribution Defense...

Basic Math
Q

Which of the following random variables are continuous variables and which are discrete a The...

Statistics
Q

11 Simplify O 3x 63x 2 49 O9x 63x 22 49 O O92 63x 49...

Algebra
Q

answer a,b and c lob Order Costina The MIL Copporation peoduces...

Accounting
Q

Brady Construction Company contracted to build an apartment complex for a price of $5,100,000. Construction...

Accounting
Q

With financial calculator values please! Personal Finance Problem Accumulating a growing future...

Accounting
Q

The rate of earnings is 6% and the cash to be received in 4 years...

Accounting
Q

Assume Gillette Corporation will pay an annual dividend of $0.61 one year from now. Analysts...

Finance