logo

Crowdly

Browser

Add to Chrome

Based on these net present value calculations in Lab 5.7 Excel: Assessing the R...

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Based on these net present value calculations in Lab 5.7 Excel: Assessing the Returns to Education: To MBA or Not to MBA, at which age does the higher payoff begin for getting an MBA (as compared to not getting an MBA)?

The data in the table for getting an M B A. N P V: $756, 604.06. The data from age 25 to 60 across 2 column is as follows: 25, -$20,000.00, -$18,348.62 26, -$20.000.00,-$16,833.60 27, -$20,000.00, -$15,443.67 28, $75,000.00, $53,131.89 29, $77,250.00, $50.207.20 30, $79,567.50, $47,443.50 31, $81,954.53, $44,831.93 32, $84.413.16, $42364.12 33, $86,945.56, $40,032.15 34, $89,351.92, $37,828.54 35, $92,240.54, $35,746.44 36, $95,007.76, $33,778.36 37, $97,857.99, $31,919.19 38, $100,793.73, $30,162.17 39, $103,817.44, $28,501.46 40, $106,932.07, $26,932.95 41, $110,140.03, $25450.41 42, $113,444.23, $24,049.47 43, $116,847.56, $22,725.64 44, $120,352.98, $21,474.69 45, $123.963.57, $20,292.60 46, $127.682.48, $19,175.37 47, $131.512.95, $18,120.04 48, $135,458.34, $17.122.60 49, $139,522.09, 516,180.08 50, $143.707.76, $1428943 51, $148,018.99, $14,447.81 52, $152.459.56, $13,652.52 53, $157,033.34, $12,901.00 54, $161,744.35, $12,190.86 55, $166,596.68, $11,519.80 56, $171,594.58, $10,885.68 57, $176,742.41, $10,286.47 58, $182,044.69, $9,720.24 59, $187,506.03, $9,185.18 60, $193.131.21, $8,679.58 The data in the table for not getting an M B A. N P V: $583,923.03. The data from age 25 to 60 column is as follows: 25, $45,000.00 26, $45,900.00 27, $46,818.00 28, $47,754.36 29, $48,709.45 30, $49,683.64 31, $50,677.31 32, $51,690.86 33, $52,724.67 34, $53,779.17 35, $54,854.75 36, $55,951.84 37, $57,070.88 38, $58,212.30 39, $59,376.54 40, $60,564.08 41, $61,775.36 42, $63,010.86 43, $64,271.08 44, $65,556.50 45, $66,867.63 46, $68,204.99 47, $69,569.09 48, $70,960.47 49, $72,379.68 50, $73,827.27 51, $75,303.82 52, $76,809.89 53, $78,346.09 54, $79,913.01 55, $81,511.27 56, $83,141.50 57, $84,804.33 58, $86,500.41 59, $88,230.42 60, $89,995.03

0%
100%
0%
0%
More questions like this

Want instant access to all verified answers on moodle.polytechnic.bh?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Browser

Add to Chrome

TelegramInstagramTikTokQuestion Bank
Terms of UseContact Us