Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suzanne is recently retired and enjoys quilting. She is considering starting a quilting business to keep her busy in her retirement. She has 2 options

Suzanne is recently retired and enjoys quilting. She is considering starting a quilting business to keep her busy in her retirement. She has 2 options when purchasing a long-arm quilting machine. A) She can purchase a longarm quilting machine for $17,000, with this machine she believes that she will be able to quilt 7.5 quilts a week. B) She could purchase an automated quilting machine for $40,000, using this machine she believes that she will be able to quilt 4 quilts a day for 5 days a week. In either case, Suzanne figures she can charge 4 cents a square inch and make about $70 per quilt (an average quilt is about 36x48 inches). She also figures that each quilt will cost her about $20 dollars in material (batting and thread). She expects to run her quilting company for 5 years and expects that her sales and costs will each increase each year by 5%. She will have no relevant fixed expenses as she will operate the business out of her own home. She will use straight-line depreciation for each of the 5 years (annual depreciation is $3400). Taxes are 21%. Assume she has a 10% discount rate if she takes project A and a 15% discount rate if she takes project B, calculate the: NPV? IRR? PI ratio? Payback period? Assuming that the projects are mutually exclusive, which if any should she do? Briefly explain why?

Please, I need the answer in an Excel sheet

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

The Major Accounting Firms Understanding The Role Of Global Auditing Giants

Authors: Seth Nashe

1st Edition

B0CGKZ5Y2Q, 979-8859081318

More Books

Students also viewed these Accounting questions

Question

Define codon and anticodon. How do they interact?

Answered: 1 week ago

Question

2. Identify the four elements of the promotion mix.

Answered: 1 week ago

Question

4. Devise an interview strategy from the interviewers point of view

Answered: 1 week ago