FREE Trial
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 with AI-Powered 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

Students also viewed these Finance questions

Question

10.73 Use Table 4 in Appendix I to find the following critical values: a. An upper one-tailed rejection region with = 0.05 and 11 df b. A two-tailed rejection region with a = 0.05 and 7 df c. A lower...

Answered: 1 week ago

Question

★★★★★
In what way could African slaves maintain a degree of control over their situation as salves and their being forced to live a foreign culture?

Answered: 1 week ago

Question

★★★★★
Required information Exercise 16-12 (Algo) Indirect: Preparing statement of cash flows LO P2, P3, A1 Skip to question [The following information applies to the questions displayed below.] The...

Answered: 1 week ago

Question

★★★★★
Please answer the following questions below with long short essay responses: 1. Dr. Malic has conducted a number of experiments to assess whether playing violent video games makes people become more...

Answered: 1 week ago

Question

★★★★★
What has been your desire for leadership in CVS Health?

Answered: 1 week ago

Question

★★★★★
A retail store keeps its products on average for 100 days in inventory. The business takes around 50 days to pay its invoices from suppliers and it normally takes 21 days to collect payments from its...

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

★★★★★
On a recent road trip to the Big Easy, the absentee landlord recorded his gasoline purchases in a logbook that he intended to support his rental expenses for the year. The entries are in the table...

Answered: 1 week ago

Question

★★★★★
Using the cost approach to value, determine the value of parcel with land value of $30,000, replacement cost of the building is $50.00 per square foot, with the area of 1,500 square feet, and...

Answered: 1 week ago

Previous Question Next Question