Question

In: Accounting

prepare a capital budget for a project such as building or renovating a facility. Required: Determine...

prepare a capital budget for a project such as building or renovating a facility.

Required:

Determine the total cost of the project and the source of funds for the project.

Did the cost of the project stay within budget?

If the present value method was used, review the calculations. Do you agree with the calculations and methods used?

If the present value was not used to evaluate the project, estimate the project’s net present value.

Evaluate the capital budgeting procedures that were actually used by your university.

Solutions

Expert Solution

I am taking simple figures. Lets say a company wants to build a plant and the cost is $ 50,000 and $ 50,000 in year 1 and year 2 which will be arranged from loan. after such building the plant will fetch $ 20,000 a year. and the estimated useful life of the plant is 6 years. after that its residual value will remain $ 10,000. let the discounting rate or present value factor be 10%.

Net Present Value = Present value of cash inflow - Present value of cash outflow

= $ 95455 - $ 92720

= - $ 2735 or ( 2735 )

here cash outflow is greater than cash inflow, therefore NPV is negative i.e it is not ideal to invest in such project.

IRR, payback period, PI index etc can also be used but NPV is the best method , it considers the present value of future cash flows. consider risk factors and is a good measure of profitability.

present value of cash outflow = $ 95455

year cost/outflow PV factor amount
1 50,000 1 50,000
2 50,000 0.909 45,455
Total 95,455

present value of cash inflow = $ 92720

year income/inflow PV factor amount
1 20000 0.909 18,180
2 20000 0.826 16,520
3 20000 0.751 15,020
4 20000 0.683 13,660
5 20000 0.621 12,420
6 20000 0.564 11,280
residual 10000 0.564 5,640
Total 92,720

Related Solutions

A project involves renovating a manufacturing facility to improve profits for a company. The expected cash...
A project involves renovating a manufacturing facility to improve profits for a company. The expected cash flow amounts over the 15-year useful life of the project are shown below. The company has established a MARR of 18%. Determine whether the company should proceed with the upgrades using the following methods: a. Internal rate of return method (IRR) b. External rate of return method (ERR), with external reinvestment rate ε = 12% Initial capital investment: $95,000 Annual expenses: $14,500 Annual revenues:...
Required: 1. Prepare the Sales budget for 2019. 2. Prepare the Production budget for 2019. 3....
Required: 1. Prepare the Sales budget for 2019. 2. Prepare the Production budget for 2019. 3. Prepare the Direct materials purchases budget (units and dollars) for 2019. 4. Prepare the Direct labor budget for 2019. 5. Prepare the Factory overhead budget for 2019. 6. Prepare the Cost of goods sold and ending finished goods inventory budgets for 2019. 7. Prepare the Selling and administrative expense budget, broken down into two components: Selling Expenses, and Administrative Expenses for 2019. 8. Prepare...
WACC & Capital Budget Analysis Based on the inputs below prepare a capital budget analysis for...
WACC & Capital Budget Analysis Based on the inputs below prepare a capital budget analysis for this Base Case using the Net Present Value, Internal Rate of Return, Profitability Index and Payback in years methods, determining whether the project is feasible. Please show your spreadsheet calculations and your final determinations of “go” or “no go” on the project. Project Inputs: WACC – Debt is 70% and Equity is 30% of this firm’s capital structure. Interest rate on the debt is...
WACC & Capital Budget Analysis Based on the inputs below prepare a capital budget analysis for...
WACC & Capital Budget Analysis Based on the inputs below prepare a capital budget analysis for this Base Case using the Net Present Value, Internal Rate of Return, Profitability Index and Payback in years methods, determining whether the project is feasible. Please show your spreadsheet calculations and your final determinations of “go” or “no go” on the project. Use your Investment Return Analysis as an example for this capital budget analysis. Project Inputs: WACC – Debt is 70% and Equity...
Explain the process to prepare and develop a capital budget.
Explain the process to prepare and develop a capital budget.
1. Jade is renovating his bathroom and as part of the renovations a plumber is required...
1. Jade is renovating his bathroom and as part of the renovations a plumber is required to install a new shower. The budget for this part of the renovations is $1000. An industry expert has told Jade that the probability that a randomly selected plumber in Auckland will be able to do the job for $1000 or less is 0.55, and that a list of plumbers located in Auckland is available from the Plumbers, Gasfitters and Drainlayers Board website. There...
3). You are required to prepare a cash budget (by filling in the gaps in the...
3). You are required to prepare a cash budget (by filling in the gaps in the Table-A provided below) for the Lollypop Bhd for the month of July, August, and September 2019. The company’s cash receipts and cash disbursements are provided in the table based on the amount of projected sales and the purchase (expenses) payments respectively for the month of July, August, and September. Month July August September Cash receipts RM127,500 RM152,500 RM145,000 Cash disbursements RM133,000 RM142,404 RM114,000 The...
3). You are required to prepare a cash budget (by filling in the gaps in the...
3). You are required to prepare a cash budget (by filling in the gaps in the Table-A provided below) for the Lollypop Bhd for the month of July, August, and September 2019. The company’s cash receipts, and cash disbursements are provided in the table based on the amount of projected sales and the purchase (expenses) payments respectively for the month of July, August, and September. Month July August September Cash receipts RM127,500 RM152,500 RM145,000 Cash disbursements RM133,000 RM142,404 RM114,000 The...
Project A Project B Cost of equipment required $ 155,000 $ 0 Working capital investment required...
Project A Project B Cost of equipment required $ 155,000 $ 0 Working capital investment required $ 0 $ 155,000 Annual cash inflows $ 25,000 $ 40,000 Salvage value of equipment in six years $ 8,600 $ 0 Life of the project 6 years 6 years The working capital needed for project B will be released at the end of six years for investment elsewhere. Perit Industries’ discount rate is 14%. Click here to view Exhibit 12B-1 and Exhibit 12B-2,...
Question #1: WACC & Capital Budget Analysis – Based on the inputs below prepare a capital...
Question #1: WACC & Capital Budget Analysis – Based on the inputs below prepare a capital budget analysis for this Base Case using the Net Present Value, Internal Rate of Return, Profitability Index and Payback in years methods, determining whether the project is feasible. Please show your spreadsheet calculations and your final determinations of “go” or “no go” on the project. Use your Investment Return Analysis as an example for this capital budget analysis. Project Inputs: WACC – Debt is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT