Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

AutoSave O Off) HC 306 - Unit 5 Assignment - Protected View . Search (Alt+Q) Amanda Lane AL X File Home Insert Page Layout Formulas

image text in transcribedimage text in transcribed
image text in transcribedimage text in transcribed
AutoSave O Off) HC 306 - Unit 5 Assignment - Protected View . Search (Alt+Q) Amanda Lane AL X File Home Insert Page Layout Formulas Data Review View Help Comments Share PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X H4 X v fx A B D E G H 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. 2 3 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 $ each Net Present Value (NPV) # of treatments at $ 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 10 Example: 3 at $,1000 S 3,000 Cash flow month 1 Example: 3 at $,1000 $ 3,000 Cash flow month 1 11 Cash flow month 2 Cash flow month 2 12 Cash flow month 3 Cash flow month 3 13 Cash flow month 4 Cash flow month 4 14 Cash flow month 5 Cash flow month 5 15 Cash flow month 6 Cash flow month 6 16 17 $ (22,321.43) NPV

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

Cornerstones of Managerial Accounting

Authors: Maryanne Mowen, Don Hanson, Dan Heitger, David McConomy, Bradley Witt, Jeffrey Pittman

3rd Canadian edition

176530886, 176721231, 978-0176721237

More Books

Students also viewed these Accounting questions

Question

Explain how the magnetic audit trail functions.

Answered: 1 week ago

Question

Income of Suaro (35,000)

Answered: 1 week ago