Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with my assignment that is due today, I have completed the assignment, however, I am not sure if I completed it correctly.

I need help with my assignment that is due today, I have completed the assignment, however, I am not sure if I completed it correctly.

HC 306 - Unit 5 Assignment
You are a practice manager for Eden Wellness and Aesthetics - a successful and high patient volume med-spa. As the practice manager, you are responsible for arranging financing for equipment purchases and determining pricing for new services. You have been asked to purchase a laser machine, with a purchase price of $25,000. You will need to determine the treatment price for patients, and how many treatments must be sold to reach a profitable return on the investment. For this scenario, you will only be factoring in the cost of purchasing the laser machine, not additional costs of supplies, administrative expenses, etc.
Consider this information as you work through the Excel document:
Opportunity cost of capital is 12% Estimate cash flows (treatment price) for six months Competitor pricing for this procedure is $1,200
COMPLETE ALL YELLOW CELLS
# of treatments at $ 1167.00 each Net Present Value (NPV) # of treatments at $1167.00 each Internal Rate of Return (IRR)
12% Project (opportunity) cost of capital 12% Project (opportunity) cost of capital
$ (25,000) Cash flow month 0 $ (25,000) Cash flow month 0
Example: 4 at $1167.00 $ 4,668 Cash flow month 1 Example: 4 at $ 1167.00 $ 4,668 Cash flow month 1
$ 4,668 Cash flow month 2 $ 4,668 Cash flow month 2
$ 4,668 Cash flow month 3 $ 4,668 Cash flow month 3
$ 4,668 Cash flow month 4 $ 4,668 Cash flow month 4
$ 4,668 Cash flow month 5 $ 4,668 Cash flow month 5
$ 4,668 Cash flow month 6 $ 4,668 Cash flow month 6
$ (5,807.95) NPV <-- a formula is used in this cell so calculations are automatic 3% IRR <-- a formula is used in this cell so calculations are automatic
For this to be a profitible investment, should NPV be positive or negative? For this to be a profitible investment, should IRR exceed the project cost of capital or not?
In order for the investment to be profitible, the NPV should be positive. For the IRR to be a profitible invsetment, the IRR should be postive and should exceed the prohect cost of capital.
Briefly explain when profitibility will be achieved (how many months or treatments sold).
Profitibility was achieved during month 6 of cash flow. Specifically, it was achieved at 22 units.

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_2

Step: 3

blur-text-image_3

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

Advances In Mathematical Economics Volume 19

Authors: Shigeo Kusuoka, Toru Maruyama

1st Edition

4431554890, 9784431554899

More Books

Students also viewed these Mathematics questions