Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. write an excel formula using the vlookup function

Write an excel formula using the vlookup function to find the payback period. Find rate...

80.2K

Verified Solution

Question

Finance

imageWrite an excel formula using the vlookup function to find the payback period. Find rate of return as well.

\begin{tabular}{|r|r|r|} \hline Year & Cash flow & Cummulative CF \\ \hline 0 & 500,000 & 500,000 \\ \hline 1 & 60,000 & 440,000 \\ \hline 2 & 90,000 & 350,000 \\ \hline 3 & 83,000 & 267,000 \\ \hline 4 & 79,000 & 188,000 \\ \hline 5 & 103,000 & 85,000 \\ \hline 6 & 102,000 & 17,000 \\ \hline 7 & 104,000 & 121,000 \\ \hline 8 & 119,000 & 240,000 \\ \hline 9 & 131,000 & 371,000 \\ \hline 10 & 114,000 & 485,000 \\ \hline \end{tabular}

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

Medical Sciences
1.2K views

Which of the following processes draws energy directly from the hydrolysis of ATP? simple diffusion facilitated diffusion primary active...

Chemistry
1.2K views

Calculate the pH change that results when 11 mL of 5.8 M NaOH is added to...

Physics
1.2K views

Consider an object whose initial displacement and velocity are both equal to zero with respect to...

Psychology
1.2K views

Everyone knows that peers have powerful influence in the teen years. Friend selection can be crucial...

Advance Math
1.2K views

Given a natural number q ? 1, define a relation ? on the set Z by...

Physics
1.2K views

Aakash Rank Boost 1 An ideal monoatomic gas is carried around the cycle ABCDA as...

Accounting
1.2K views

LMO Company incurred expenditures for leasehold improvements during the year. The relevant lease is on...

Accounting
1.2K views

TB MC Qu. 20-126 (Algo) Wichita Industries' sales are... Wichita Industries' sales are 10% cash...

Accounting
1.2K views

The Bottling Department of Mountain Springs Water Company had 4,100 liters in beginning work in...

Accounting
1.2K views

Exerclse 8-21A (Algo) Computing and recording the amortization of Intanglbles LO 8-10, 8-11 Dynamo Manufacturing...

Accounting
1.2K views

Given the following information, determine the cost of the inventory at June 30 using the...

Finance
1.2K views

Please include steps with explanations and formulas. 4) There are two underlying assets in...