AIU Net Present Value and Simple Payback Period Calculation Worksheet

User Generated

Wnznvpnw1125

Business Finance

American InterContinental University

Description

Submit an Excel spreadsheet answering all questions. Assignment details are attached.

Attachment preview

Your neighborhood self-service laundry is for sale and you consider investing in this business. For the business alone and no other assets (such as building and land), the purchase price is $240,000. The net cash flows 

Unformatted Attachment Preview

studentlogin.aiuniv.edu G Learning Management System + Learning Management System document, and then click "OK" to finish. Assignment Details Deal or No Deal? Your neighborhood self-service laundry is for sale and you consider investing in this business. For the business alone and no other assets (such as building and land), the purchase price is $240,000. The net cash flows for the project are $30,000 per year for the next 5 years. You plan to borrow the money for this investment at 5%. 1. Prepare a net present value calculation for this project. What is the net present value of this project? 2. Calculate the simple payback period for this project. Your desired payback period is 5 years. How long is the payback period for this project? 3. Is this a good investment? What would be a good price at which to purchase this business? Submit an Excel spreadsheet which must include the answers to all 3 questions: 1) A Net Present Value calculation, 2) a Simple Payback Period calculation, and 3) the answer to question regarding whether this is a good investment and what the best price should be. The use of 1 scholarly source (e.g., textbook, article from the CEC Library) is required. If you are planning to repurpose an assignment or submit one you have used before, please let your instructor know. If an instructor is not made aware of work being repurposed or reused, he or she will treat the assignment as a plagiarized task and reserves the right to post an F grade and submit a task for review to administration until proof of originality is provided. Click here for more information. The following are some tips if you have problems submitting your assignment: 1. Resave in the proper format per the Assignment Detail instructions, and resubmit. 2. Submit with a different Web browser. 3. Submit from a different computer. 4. Call Technical Support at 877-221-5800, Menu Option 2. They are open 24/7. 5. If you are still having difficulties after trying steps 1-4, please contact your course instructor. Make sure you submit this assignment by the listed due date. Late deductions will apply for this assignment as follows: 1. Assignments submitted within 7 calendar days after the stated due date: 10% penalty of total assignment points. 2. Assignments submitted 8-14 calendar days after the stated due date: 20% penalty of total assignment points. 3. Assignments submitted 15-21 calendar days after the stated due date: 30% penalty of total assignment points. 4. Assignments submitted 22-28 calendar days after the stated due date: 40% penalty of total assignment points. 5. No assignments, including late assignments, will be accepted after the end of the course unless an approved Incomplete has been granted. Feedback
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

check this and let me know if you need any help......

1)

Year
0
1
2
3
4
5

Cash Inflow/Outflow
-240.000
30.000
30.000
30.000
30.000
30.000
Net Present Value

Present Value
-240.000
28.571
27.211
25.915
24.681
23.506
-110.115,70

2) Pay back Period:
Year
Cash Inflow/Outflow Cumulative cashflow
0
-240.000
-240.000
1
30.000...


Anonymous
Just what I was looking for! Super helpful.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Content

Related Tags