Apersonal assessment of each course of the Graduate Business program is required. This assessment, Reflections of Learning , will be representative of what was learned in the course, what can be...

1 answer below »

Apersonal assessment of each course of the Graduate Business program is required. This assessment,Reflections of Learning, will be representative of what was learned in the course, what can be applied to present or future organizations, and what will demonstrate learning accomplishments; e.g., increased knowledge or improved skills or changes in behavior, judgment, attitudes, or feelings. Follow the rubricto assist you in this assessment. Note: This is a program requirement that feeds into two required elements for the program: the Portfolio and the Exit Interview. This document should be a reflection of your best writing skills, as well as what you learned and how you improved in this course.


Whenyou have completed this assessment:





    • Submit the Reflections of Learning paperby Sunday midnight of Week 6 for each course.

    • Upload a copy of your Reflections of Learning paper to your Portfolio, selected module (e.g., Financial Management). Due by Sunday midnight after the class session of Week 6.

    • Upload copies of the following assignments from the completed module to your Portfolio(see Orientation/Home Page for Google Drive Portfolio set-up instructions); for example:

    • Capital Budgeting PowerPoint Presentation

    • Other major course projects






Project A Price20Inflation Rate2%Tax Rate40.00% Variable Cost10 Required Return9.4% Salvage Value150,000 Initial Cost2,000,000 Installation Cost130,000 Increase in NWC250,000 Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Fixed Cost200000200000200000200000200000200000200000 Units sold70000100,00065,00070,00065,00055,000 Depreciation Rate20.00%32.00%19.20%11.52%11.52%5.76% 123456 Sales1,400,0002,000,0001,300,0001,400,0001,300,0001,100,000 Variable Cost700,0001,000,000650,000700,000650,000550,000 Fixed Cost200,000200,000200,000200,000200,000200,000 EBITDA500,000800,000450,000500,000450,000350,000 Depreciation426,000681,600408,960245,376245,376122,688 EBIT74,000118,40041,040254,624204,624227,312 Tax Expense29,60047,36016,416101,85081,85090,925 Net Income44,40071,04024,624152,774122,774136,387 Operating Cash Flow470,400752,640433,584398,150368,150259,075 Non-operating Cash Flow60,000 Capital Expenditures Cash Flow2,174,400 Net Working Capital Cash Flow194,400250000 Total Cash Flows Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Total Cash Flows-2,130,000470,400752,640433,584398,150368,150569,075 Cumulative Cash Flow-1,659,600-3,789,600-1,696,416-1,731,850-1,761,850-1,560,925 Internal Rate of Return11% Modified Internal Rate of Return10% Net Present Value$ 4,364,819 Payback Period3.21 Profitability Index3.0 Prj A Section4 Reduction of Price by 10% Price18Inflation Rate2%Tax Rate40.00% Variable Cost10 Required Return9.4% Salvage Value150,000 Initial Cost2,000,000 Installation Cost130,000 Increase in NWC250,000 Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Fixed Cost200000200000200000200000200000200000200000 Units sold70000100,00065,00070,00065,00055,000 Depreciation Rate20.00%32.00%19.20%11.52%11.52%5.76% 123456 Sales1,260,00000000 Variable Cost1,260,0001,800,0001,170,0001,260,0001,170,000990,000 Fixed Cost200,000200,000200,000200,000200,000200,000 EBITDA-200,000-2,000,000-1,370,000-1,460,000-1,370,000-1,190,000 Depreciation426,000681,600408,960245,376245,376122,688 EBIT-626,000-2,681,600-1,778,960-1,705,376-1,615,376-1,312,688 Tax Expense-250,400-1,072,640-711,584-682,150-646,150-525,075 Net Income-375,600-1,608,960-1,067,376-1,023,226-969,226-787,613 Operating Cash Flow50,400-927,360-658,416-777,850-723,850-664,925 Non-operating Cash Flow60,000 Capital Expenditures Cash Flow1,754,400 Net Working Capital Cash Flow-225,600250000 Total Cash Flows Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Total Cash Flows-2,130,00050,400-927,360-658,416-777,850-723,850-354,925 Cumulative Cash Flow-2,079,600-4,209,600-2,788,416-2,907,850-2,853,850-2,484,925 Internal Rate of ReturnERROR:#NUM! Modified Internal Rate of Return-49% Net Present Value$ -4,573,612 Payback Period-1.24 Profitability Index3.1 Prj A Section5 Reduction of Sales volume by 10% Price20Inflation Rate2%Tax Rate40.00% Variable Cost10 Required Return10% Salvage Value150,000 Initial Cost2,000,000 Installation Cost130,000 Increase in NWC250,000 Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Fixed Cost200000200000200000200000200000200000200000 Units sold6300090,00058,50063,00058,50049,500 Depreciation Rate20.00%32.00%19.20%11.52%11.52%5.76% 123456 Sales1,260,00000000 Variable Cost1,260,0001,800,0001,170,0001,260,0001,170,000990,000 Fixed Cost200,000200,000200,000200,000200,000200,000 EBITDA-200,000-2,000,000-1,370,000-1,460,000-1,370,000-1,190,000 Depreciation426,000681,600408,960245,376245,376122,688 EBIT-626,000-2,681,600-1,778,960-1,705,376-1,615,376-1,312,688 Tax Expense-250,400-1,072,640-711,584-682,150-646,150-525,075 Net Income-375,600-1,608,960-1,067,376-1,023,226-969,226-787,613 Operating Cash Flow50,400-927,360-658,416-777,850-723,850-664,925 Non-operating Cash Flow60,000 Capital Expenditures Cash Flow1,754,400 Net Working Capital Cash Flow-225,600250000 Total Cash Flows Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Total Cash Flows-2,130,00050,400-927,360-658,416-777,850-723,850-354,925 Cumulative Cash Flow-2,079,600-4,209,600-2,788,416-2,907,850-2,853,850-2,484,925 Internal Rate of ReturnERROR:#NUM! Modified Internal Rate of Return-49% Net Present Value$ 4,526,354 Payback Period-1.24 Profitability Index3.1 Project B Price40Inflation Rate2%Tax Rate40.00% Variable Cost15 Required Return10% Salvage Value50,000 Initial Cost2,000,000 Installation Cost100,000 Increase in NWC70,000 Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Fixed Cost150000150000150000150000150000150000150000 Units sold500005000060,00070,00080,00090,00080,000 Depreciation Rate20.00%32.00%19.20%11.52%11.52%5.76% 123456 Sales2,000,0002,400,0002,800,0003,200,0003,600,0003,200,000 Variable Cost750,000900,0001,050,0001,200,0001,350,0001,200,000 Fixed Cost150,000150,000150,000150,000150,000150,000 EBITDA1,100,0001,350,0001,600,0001,850,0002,100,0001,850,000 Depreciation220,000432,000307,200213,120241,920106,560 EBIT880,000918,0001,292,8001,636,8801,858,0801,743,440 Tax Expense352,000367,200517,120654,752743,232697,376 Net Income528,000550,800775,680982,1281,114,8481,046,064 Operating Cash Flow1,038,0001,484,8001,460,0801,478,3681,668,6881,329,184 Non-operating Cash Flow120,000 Capital Expenditures Cash Flow2,918,000 Net Working Capital Cash Flow868,000 Total Cash Flows Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Total Cash Flows-20000001,038,0001,484,8001,460,0801,478,3681,668,6881,449,184 Cumulative Cash Flow-962,000-2,962,000-539,920-521,632-331,312-550,816 Internal Rate of Return62% Modified Internal Rate of Return33% Net Present Value$ 4,131,619 Payback Period1.65 Profitability Index3.1 Prj B Section4 Reduction of Price by 10% Price36Inflation Rate2%Tax Rate40.00% Variable Cost15 Required Return10% Salvage Value50,000 Initial Cost2,000,000 Installation Cost100,000 Increase in NWC70,000 Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Fixed Cost150000150000150000150000150000150000150000 Units sold500005000060,00070,00080,00090,00080,000 Depreciation Rate20.00%32.00%19.20%11.52%11.52%5.76% 123456 Sales1,800,0002,160,0002,520,0002,880,0003,240,0002,880,000 Variable Cost750,000900,0001,050,0001,200,0001,350,0001,200,000 Fixed Cost150,000150,000150,000150,000150,000150,000 EBITDA900,0001,110,0001,320,0001,530,0001,740,0001,530,000 Depreciation180,000355,200253,440176,256200,44888,128 EBIT720,000754,8001,066,5601,353,7441,539,5521,441,872 Tax Expense288,000301,920426,624541,498615,821576,749 Net Income432,000452,880639,936812,246923,731865,123 Operating Cash Flow862,0001,233,2801,216,8161,234,7581,394,6271,111,379 Non-operating Cash Flow7,052,861 Capital Expenditures Cash Flow682,000 Net Working Capital Cash Flow682,000 Total Cash Flows Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Total Cash Flows-2000000862,0001,233,2801,216,8161,234,7581,394,6278,164,240 Cumulative Cash Flow-1,138,000-766,720-783,184-765,242-605,3736,164,240 Internal Rate of Return63% Modified Internal Rate of Return41% Net Present Value$ 7,034,899 Payback Period1.92 Profitability Index4.5 Prj B Section5 Reduction of Sales volume by 10% Price36Inflation Rate2%Tax Rate40.00% Variable Cost15 Required Return10% Salvage Value50,000 Initial Cost2,000,000 Installation Cost100,000 Increase in NWC70,000 Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Fixed Cost150000150000150000150000150000150000150000 Units sold50000450005400063000720008100072000 Depreciation Rate20.00%32.00%19.20%11.52%11.52%5.76% 123456 Sales1,620,0001,944,0002,268,0002,592,0002,916,0002,592,000 Variable Cost675,000810,000945,0001,080,0001,215,0001,080,000 Fixed Cost150,000150,000150,000150,000150,000150,000 EBITDA795,000984,0001,173,0001,362,0001,551,0001,362,000 Depreciation159,000314,880225,216156,902178,67578,451 EBIT636,000669,120947,7841,205,0981,372,3251,283,549 Tax Expense254,400267,648379,114482,039548,930513,420 Net Income381,600401,472568,670723,059823,395770,129 Operating Cash Flow769,6001,101,2321,089,1021,106,8631,250,745997,032 Non-operating Cash Flow6,314,575 Capital Expenditures Cash Flow610,600 Net Working Capital Cash Flow610,600 Total Cash Flows Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Total Cash Flows-2000000769,6001,101,2321,089,1021,106,8631,250,7457,311,606 Cumulative Cash Flow-1,230,400-898,768-910,898-893,137-749,2555,311,606 Internal Rate of Return57% Modified Internal Rate of Return39% Net Present Value$ 6,087,832 Payback Period2.12 Profitability Index4.0 As per the sensitivity analysis we can conclude that reduction in price and reduction in sales volume definetely going to effect the companies future earnings. Project C Price30Inflation Rate2%Tax Rate40.00% Variable Cost10 Required Return10% Salvage Value200,000 Initial Cost2,000,000 Installation Cost50,000 Increase in NWC120,000 Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Fixed Cost100000100000100000100000100000100000100000 Units sold30,00040,00050,00060,00070,00080,000 Depreciation Rate20.00%32.00%19.20%11.52%11.52%5.76% 123456 Sales900,0001,200,0001,500,0001,800,0002,100,0002,400,000 Variable Cost300,000400,000500,000600,000700,000800,000 Fixed Cost100,000100,000100,000100,000100,000100,000 EBITDA500,000700,000900,0001,100,0001,300,0001,500,000 Depreciation100,000224,000172,800126,720149,76086,400 EBIT400,000476,000727,200973,2801,150,2401,413,600 Tax Expense160,000190,400290,880389,312460,096565,440 Net Income240,000285,600436,320583,968690,144848,160 Operating Cash Flow560,000853,600901,920957,4081,109,6641,140,960 Non-operating Cash Flow320,000 Capital Expenditures Cash Flow2,510,000 Net Working Capital Cash Flow660,000 Total Cash Flows Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Total Cash Flows-2000000560,000853,600901,920957,4081,109,6641,460,960 Cumulative Cash Flow-1,440,000-3,440,000-1,098,080-1,042,592-890,336-539,040 Internal Rate of Return36% Modified Internal Rate of Return24% Net Present Value$ 2,059,782 Payback Period2.69 Profitability Index2.0 Prj C Section4 Reduction of Price by 10% Price27Inflation Rate2%Tax Rate40.00% Variable Cost10 Required Return10% Salvage Value200,000 Initial Cost2,000,000 Installation Cost50,000 Increase in NWC120,000 Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Fixed Cost100000100000100000100000100000100000100000 Units sold30,00040,00050,00060,00070,00080,000 Depreciation Rate20.00%32.00%19.20%11.52%11.52%5.76% 123456 Sales810,0001,080,0001,350,0001,620,0001,890,0002,160,000 Variable Cost300,000400,000500,000600,000700,000800,000 Fixed Cost100,000100,000100,000100,000100,000100,000 EBITDA410,000580,000750,000920,0001,090,0001,260,000 Depreciation82,000185,600144,000105,984125,56872,576 EBIT328,000394,400606,000814,016964,4321,187,424 Tax Expense131,200157,760242,400325,606385,773474,970 Net Income196,800236,640363,600488,410578,659712,454 Operating Cash Flow480,800727,840771,600820,378949,795977,606 Non-operating Cash Flow4,728,019 Capital Expenditures Cash Flow398,800 Net Working Capital Cash Flow398,800 Total Cash Flows Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Total Cash Flows-2000000480,800727,840771,600820,378949,7955,705,626 Cumulative Cash Flow-1,519,200-1,272,160-1,228,400-1,179,622-1,050,2053,705,626 Internal Rate of Return43% Modified Internal Rate of Return32% Net Present Value$ 3,989,080 Payback Period3.09 Profitability Index3.0 Prj C Section5 Reduction of Sales volume by 10% Price30Inflation Rate2%Tax Rate40.00% Variable Cost10 Required Return10% Salvage Value200,000 Initial Cost2,000,000 Installation Cost50,000 Increase in NWC120,000 Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Fixed Cost100000100000100000100000100000100000100000 Units sold27,00036,00045,00054,00063,00072,000 Depreciation Rate20.00%32.00%19.20%11.52%11.52%5.76% 123456 Sales810,0001,080,0001,350,0001,620,0001,890,0002,160,000 Variable Cost270,000360,000450,000540,000630,000720,000 Fixed Cost100,000100,000100,000100,000100,000100,000 EBITDA440,000620,000800,000980,0001,160,0001,340,000 Depreciation88,000198,400153,600112,896133,63277,184 EBIT352,000421,600646,400867,1041,026,3681,262,816 Tax Expense140,800168,640258,560346,842410,547505,126 Net Income211,200252,960387,840520,262615,821757,690 Operating Cash Flow507,200769,760815,040866,0541,003,0851,032,058 Non-operating Cash Flow4,993,197 Capital Expenditures Cash Flow419,200 Net Working Capital Cash Flow419,200 Total Cash Flows Year 0Year 1Year 2Year 3Year 4Year 5Year 6 Total Cash Flows-2000000507,200769,760815,040866,0541,003,0856,025,254 Cumulative Cash Flow-1,492,800-1,230,240-1,184,960-1,133,946-996,9154,025,254 Internal Rate of Return45% Modified Internal Rate of Return33% Net Present Value$ 4,325,070 Payback Period2.94 Profitability Index3.2 As per the sensitivity analysis we can conclude that reduction in price and reduction in sales volume definetely going to effect the companies future earnings. 1 2 3 4 5 6 A B Price 40 Variable Cost 15 Required Return 10% Salvage Value 50,000
Answered Same DayJul 03, 2021

Answer To: Apersonal assessment of each course of the Graduate Business program is required. This assessment,...

Khushboo answered on Jul 04 2021
149 Votes
1. Major learnings from capital budgeting techniques:
We have learnt that capital budgeting is a very useful technique for decision making. The investment decisions can be ana
lysed based on various evaluation criteria and various techniques such as NPV, IRR, PI index and payback period (Jaye Thompson, 2018). We have also learnt that how these techniques can be analysed and how investment decisions can be evaluated.
2. Examples which helped to gain knowledge and learnings:
We have learned the practical application of capital budgeting techniques by evaluating three projects criteria which are as below:
There are three projects: project A; project B; and project c. All three projects require initial investment of 20,00,000 and having project durations of 6 years. However, the revenue and cash outflows of all three projects are different. We have firstly calculated the net cash outflows for each project and the net outcome of three projects are as below:
    Particulars
    Project A
    Project B
    Project C
    Internal Rate of Return
    11%
    62%
    36%
    Modified Internal Rate of Return
    10%
    33%
    24%
    Net Present Value
     43,64,819
    4131619
    2059782
    Payback Period
     3.21
     1.65
     2.69
    Profitability Index
     3.05
     3.07
     2.03
In the above example, we have learnt that based on different criteria, the selection decision may be different so the decision should be selected carefully. For example, based on IRR and MIRR we will prefer the Project C having highest IRR, based on NPV and profitability index, Project A will be considered due to having highest NPV and...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here