Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Annual Revenue = $55,000 Tenure = 7 Years Discounting rate = 8.2% Present value of revenues = $55,000 * PVAF(8.2%,7) = $55,000 * (1-(1+0.082)^-7)/0.082 =

Annual Revenue = $55,000 Tenure = 7 Years Discounting rate = 8.2% Present value of revenues = $55,000 * PVAF(8.2%,7) = $55,000 * (1-(1+0.082)^-7)/0.082 = $55,000 * 5.170947 = $284,402.08

how would I plug this answer into excel?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Routledge Handbook Of Financial Literacy

Authors: Gianni Nicolini, Brenda J. Cude

1st Edition

0367457776, 978-0367457778

More Books

Students also viewed these Finance questions

Question

What has been your desire for leadership in CVS Health?

Answered: 1 week ago

Question

Question 5) Let n = N and Y Answered: 1 week ago

Answered: 1 week ago