Purchase Solution

Cash flow statement for an MBA degree

Not what you're looking for?

Ask Custom Question

I would like to create a cash flow statement for my MBA degree to determine if I am making the right decision. I would like to calculate the following things:

Projected cost of interest for loan
Cost of capital
Net present Value
Internal Rate of Return
Payback
Discounted Payback
Profitability Index

Please show me how all calculations are were done

Assume the following:
Degree costs 12,510
financed at a rate of 7.5% for ten years
I was offered another job making 5% more than I currently make instead of going back to school. (salary 80,000)
Assume I have 25 years left until retirement
Assume my tax rate is 30%
Assume annual raises equal to inflation of 3% annually
If any other info is needed, please list assumption used to solve

Purchase this Solution
Solution Summary

Excel file attached gives a cash flow statement for an MBA to judge its worth.

Purchase this Solution
Free BrainMass Quizzes
Lean your Process

This quiz will help you understand the basic concepts of Lean.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

View More Free Quizzes
Related BrainMass Solutions

  • Developing a Business Plan Draft

    The data for statement of cash flows can be obtained from the opening and ending balance sheet for the specific point in time and income statement for that specific point in time (Quick MBA, 2015).

  • Ben Bates (Bill Smith) graduated from college six years ago with a finance undergraduate degree

    Other nonquantifiable factors that affect Ben's decision to get an MBA might include the job achievement, the opportunity to work in the investment banks, the pride for working as an investment banker, and the pride for having a higher level of degree

  • Analysis of variance

    0.34 2.96 2.03 6.93 None of the above answers is correct * Concerning MBA degree problem statement, considering the values for sample test statistic and critical value for test statistic, what statement can be made about the null

  • Healthcare Financial Management - Income Statement, Balance

    Paul Cerisano MBA, MEd Relationships between Financial Reports, Balance Sheet, Income Statement, and Cash Flow. Solution reports on this relationship. Short form easy to read financial statements are included in the solution.

  • Using Initial Public Offering

    An understanding of the PE ratio and its use in valuation 2. An understanding of discounted cash flow methods and their application in valuation 3. Using the growth rate to estimate future cash flows 4.

  • Finance Problem: Ben Bates Case Study

    Suppose, instead of being able to pay cash for his MBA, Ben must borrow the money. The current borrowing rate is 5.4%. How would this affect his decision? 7.

  • Corporate Financial Analysis Case Study

    507030 You are a recent MBA graduate and are tasked with reviewing the Income Statement and Balance Sheet trends for Competition Bikes Inc. (Please see the attachment.)

  • decision to get MBA

    How does Ben's age affect his decision to get an MBA? 2. What other, perhaps nonquantifiable factors, affect Ben's decision to get an MBA? 6. Suppose, instead of being able to pay cash for his MBA, Ben must borrow the money.

  • A study on Inventory Methods

    CASH FLOW STATEMENT for the Period Ending February 28, 20XX Cash from Operations FIFO LIFO AVERAGE COST Net Earnings (Sales Rvenue) $52,125 $52,125 $52,125 Subtraction from Cash Increase in Inventory (30,660

View More Related Solutions