Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

perry and susan williams just retired, moved to the lake and purchased fishing equipment and a bass boat for perry's new fishing business. the total

perry and susan williams just retired, moved to the lake and purchased fishing equipment and a bass boat for perry's new fishing business. the total investment is 25,200 - the cost of the equipment and boat. susan told perry he needed to earn at least 10 percent return per year, because their retirement investment portfolio had averaged this amount over the years. surprisingly, and as a result of their investment in the equipment, they have actually been able to sell some of their catch to local restaurants at the marina. they have had positive cash flow, in excess of expenses, of $5000,$5500,$10000,$15000 over a four year period, respectivaly. at the end of their forth year at the lake, they finally decide to really retire. the Williams sell all of their equipment to some local college students for $3000, what is the NPV of the business? the answer is 3698.30, but how do you solve for this using excel. also what is the IRR on there investment in the business? the answer is 15.27, but how to solve for this using excel? thanks

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

Portfolio Of Marketing Audits Company Self Assessment Audits

Authors: David Crosby

1st Edition

1902433157, 978-1902433158

More Books

Students also viewed these Accounting questions