| 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 | |||||||||||
![]() |
|||||||||||
work 3.pdf X + ork 3.pdf?target=4df5354f-43de-4868-bae8-6d46f03c0f7d 1. Stephen Owsu is deciding whether he should get into...
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 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 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 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 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 thesale, 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 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. (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 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 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
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...