Question

work 3.pdf X + ork 3.pdf?target=4df5354f-43de-4868-bae8-6d46f03c0f7d 1. Stephen Owsu is deciding whether he should get into t
MESDPOTAMA X Homework 3pdf + S/icsfs/Homework 3.pdf?target-4df5354f-43de-4868-bae8-6d46f03dof7d 2. IRR: Mutually exclusive pr
Unequal lives: ANPV approach JBL Co. has designed a new conveyor system. Man- agement must choose among three alternative cou
X rk 3.pdf k 3.pdf?target=4df5354f-43de-4868-bae8-6d46f03 c0f7d Risk-adjusted rates of return using CAPM Centennial Catering,
Equation 11.5 to calculate the required project return for each.) b. Discuss your findings in part a, and recommend the prefe
X arget-4df5354f-43de-4868-bae8-6d46f03c0f7d Cash receipts A firm has actual sales of $65,000 in April and $60,000 in May. It
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Initial Cost
Cost of MBA program $60,000
Opportunity cost of giving up current earning $42,000
I Total Initial Cost $102,000
Incremental Cash Flows:
Rate Discount Rate=Opportunity cost of capital 5%
Nper Number of years 40
Pmt Incremental Earning $25,000
PV Present Value of incremental cash flow $428,977 (Using PV function of excel with Rate=5%, Nper=40, Pmt=-25000)
NPV=PV-I Net Present Value $326,977
NPV of MBA decision $326,977
Other Factors:
Affordability
Whether amount needs to be borrowed and cost of loan
Social acceptance of MBA
Increased Job satisfaction and self esteem
111 - X f =PV(18,19,-110) F G C D E H _ I K L M N O P Initial Cost Cost of MBA program Opportunity cost of giving up current
Add a comment
Know the answer?
Add Answer to:
work 3.pdf X + ork 3.pdf?target=4df5354f-43de-4868-bae8-6d46f03c0f7d 1. Stephen Owsu is deciding whether he should get into...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Unequal lives: ANPV approach JBL Co. has designed a new conveyor system. Man- agement must choose...

    Unequal lives: ANPV approach JBL Co. has designed a new conveyor system. Man- agement must choose among three alternative courses of action: (1) The firm can sell the design outright to another corporation with payment over 2 years; (2) it can li- cense the design to another manufacturer for a period of 5 years, its likely product life; or (3) it can manufacture and market the system itself, an alternative that will result in 6 years of cash inflows. The...

  • Cash budget: Advanced The actual sales and purchases for Xenocore, Inc., for Sep- tember and October...

    Cash budget: Advanced The actual sales and purchases for Xenocore, Inc., for Sep- tember and October 2015, along with its forecast sales and purchases for the period November 2015 through April 2016, follow. The firm makes 20% of all sales for cash and collects on 40% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be $12,000 in September and April, $15,000 in January and March, and $27,000 in February. The...

  • follow The firm makes 14% of all sales for cash and collects on 43% of its...

    follow The firm makes 14% of all sales for cash and collects on 43% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be $13,000 in September and April $17,000 in January and 000 in September and Apri, $17,000 in January and March, and $26,000 n February. The f pays cash for 9% of its purchases. It pays for 53% o s purchases in e o ing month and for 38%...

  • (Cash budget​) The Sharpe​ Corporation's projected sales for the first 8 months of 2016 are shown...

    (Cash budget​) The Sharpe​ Corporation's projected sales for the first 8 months of 2016 are shown in the following​ table: January ​$170,000 May ​ $280,000    February $100,000 June $250,000 March $115,000 July  $205,000 April $220,000 August  $130,000 Of​ Sharpe's sales, 30 percent is for​ cash, another 40 percent is collected in the month following the​ sales, and 30 percent is collected in the second month following sales. November and December sales for 2015 were $200,000 and $155,000​, respectively. Sharpe...

  • ​(Preparation of a cash budget​) Lewis Printing has projected its sales for the first 8 months...

    ​(Preparation of a cash budget​) Lewis Printing has projected its sales for the first 8 months of 2016 as​ follows: January ​$140,000    April ​$300,000 July ​$200,000    February      $100,000 May   $255,000    August       $200,000 March   $170,000 June   $180,000 Lewis collects 30 percent of its sales in the month of the​sale, 40 percent in the month following the​ sale, and the remaining 30 percent 2 months following the sale. During November and December of​ 2015, Lewis's sales were...

  • I need help solving part b which is filling out the last table. I included the...

    I need help solving part b which is filling out the last table. I included the answer to part a and the forecast sales and purchases if that helps. Thank you! follow The firm makes 14% of all sales for cash and collects on 43% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be $13,000 in September and April $17,000 in January and 000 in September and Apri, $17,000 in...

  • Could you please solve it with the formula in Excel for each step? Thank you 17-12....

    Could you please solve it with the formula in Excel for each step? Thank you 17-12. (Preparing a cash budget) Harrison Printing has projected its sales for the first eight months of 2017 as follows: January $100,000 May $275,000 February 120.000 June 200,000 March 150,000 July 200,000 April 300.000 August 180.000 Harrison collects 20 percent of its sales in the month of the sale, 50 percent in the month following the sale, and the remaining 30 percent two months following...

  • Preparation of a Cash Budget) Lewis Printing has projected its sales for the first 8 $200,000 January $100,000 april 300,000 july 180,000 February120,000 May 275,000 August June 200,000 March 1...

    Preparation of a Cash Budget) Lewis Printing has projected its sales for the first 8 $200,000 January $100,000 april 300,000 july 180,000 February120,000 May 275,000 August June 200,000 March 150,000 Lewis collects 20 percent of its sales in the month of the sale, 50 percent in the month following the sale, and the remaining 30 percent 2 months following the sale. Durin November and $175,0 mber of 2017, Lewis's sales were $220,000 and ive res raw materials 2 months in...

  • please show all work in excel Homework for Chapter 4: Problem #3 in the text (Chapter...

    please show all work in excel Homework for Chapter 4: Problem #3 in the text (Chapter 4) NOTE: PLEASE USE THE ATTACHED EXCEL FILE TITLED "Homework for Chapter 4 Excel TO SOLVE THE FOLLOWING PROBLEM. Active Life Inc., a sports equipment retailer, needs to prepare a cash budget for the first quarter of 2018. The financial staff at Active Life has forecasted the following sales figures: January February March April May STO SI S 000 250.000 $150,000 Actual sales in...

  • Use this Excel Culminating Project Template (SEE SCREENSHOT BELOW) to help you get started with your...

    Use this Excel Culminating Project Template (SEE SCREENSHOT BELOW) to help you get started with your budget You are the president of Campus Sweaters, Inc. Campus Sweaters manufacturers wool pullover v-neck sweaters of various sizes and colors. You are preparing the budgets for the first quarter of 2016 (January, February, and March). You have the following historical and projected sales in units: Actual or Projected Month Units Actual November 9,000 Actual December 8,000 Projected January 11,000 Projected February 10,000 Projected...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT