Project Control: The budget S-curve for a small project is shown: (a) Calculate and draw the S-curve of expenses against the expected owner payments; (b) Estimate the amount of interest chargeable on borrowed money and the overdraft limit needed. Markup is 10%; Owner retention is 5% (payable with last payment); Owner payment delay is 1 month; Interest rate is 12% per annum. 3. Project Control:The budget S-curve for a small projectis shown:(a) Calculate and draw the S-curve ofexpenses against the expectedowner payments;(b) Estimate the amount of interestchargeable on borrowed money andthe overdraft limit needed. Markupis 10%; Owner retention is 5%(payable with last payment); Ownerpayment delay is 1 month; Interestrate is 12% per annum.$54,000$40,000$29,000$86,000$127,000$112,000

The objective of the question is to calculate and draw the S-curve of expenses against the expected…

3. Project Control: The budget S-curve for a small project is shown: (a) Calculate and draw the S-curve of expenses against the expected owner payments; (b) Estimate the amount of interest chargeable on borrowed money and the overdraft limit needed. Markup is 10%; Owner retention is 5% (payable with last payment); Owner payment delay is 1 month; Interest rate is 12% per annum. $54,000 $40,000 $29,000 $86,000 $127,000 $112,000

3. Project Control: The budget S-curve for a small project is shown: (a) Calculate and draw the S-curve of expenses against the expected owner payments; (b) Estimate the amount of interest chargeable on borrowed money and the overdraft limit needed. Markup is 10%; Owner retention is 5% (payable with last payment); Owner payment delay is 1 month; Interest rate is 12% per annum. $54,000 $40,000 $29,000 $86,000 $127,000 $112,000

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 3R: Review the completed master budget and answer the following questions: Is Ranger Industries...

See similar textbooks

Similar questions

Senior management asks you to recommend a decision on which project(s) to accept based on the cash flow forecasts provided. Relevant information: The firm uses a 3-year cutoff when using the payback method. The hurdle rate used to evaluate capital budgeting projects is 15%. The cash flows for projects A, B and C are provided below. Project A Project B Project C Year 0 -30,000 -20,000 -50,000 Year 1 0 4,000 20,000 Year 2 7,000 5,000 20,000 Year 3 20,000 6,000 20,000 Year 4 20,000 7,000 5,000 Year 5 10,000 8,000 5,000 Year 6 5,000 9,000 5,000 Calculate the internal rate of return (IRR) for each project in excel Which projects would you accept based on the IRR criterion?
Senior management asks you to recommend a decision on which project(s) to accept based on the cash flow forecasts provided. Relevant information: The firm uses a 3-year cutoff when using the payback method. The hurdle rate used to evaluate capital budgeting projects is 15%. The cash flows for projects A, B and C are provided below. Project A Project B Project C Year 0 -30,000 -20,000 -50,000 Year 1 0 4,000 20,000 Year 2 7,000 5,000 20,000 Year 3 20,000 6,000 20,000 Year 4 20,000 7,000 5,000 Year 5 10,000 8,000 5,000 Year 6 5,000 9,000 5,000 Calculate the payback period for each project. Which project(s) would you accept based on the payback criterion?
Senior management asks you to recommend a decision on which project(s) to accept based on the cash flow forecasts provided. Relevant information: The firm uses a 3-year cutoff when using the payback method. The hurdle rate used to evaluate capital budgeting projects is 15%. The cash flows for projects A, B and C are provided below. Project A Project B Project C Year 0 -30,000 -20,000 -50,000 Year 1 0 4,000 20,000 Year 2 7,000 5,000 20,000 Year 3 20,000 6,000 20,000 Year 4 20,000 7,000 5,000 Year 5 10,000 8,000 5,000 Year 6 5,000 9,000 5,000 Calculate the net present value (NPV) for each project in excel. Which projects would you accept based on the NPV criterion?
An investment center in Shellforth Corporation was asked to identify three proposals for its capital budget. Details of those proposals are as follows. Capital Budget Proposals Capital required Annual operating return $ 96,000 $ 60,000 20,400 $ 180,000 16,200 24,960 Shellforth uses residual income to evaluate all capital budgeting projects. Its minimum required return is 10 percent. a-1. Assume you are the investment center manager. Calculate the residual income for each project? a-2. Which project do you prefer? b-1. Assume your investment center's current ROI is 18 percent and that the president of Shellforth is thinking about using ROI for the investment center's evaluation. Calculate the ROI for each project? b-2. Would your preferences for the projects listed change? Complete this question by entering your answers in the tabs below. Reg A1 Req A2 Req B1 Req B2 Assume you are the investment center manager. Calculate the residual income for each project? Project A Project B Project…
Accounting Draw the cash flow diagram for the given project below and then calculate the project net profit. The following table shows the activities description, dependency, duration, and cost elements. Assume the followings: Project overhead 8%. Tax 3%. Bond 1.25%. Profit 6%. Interest rate 9% per year. Down payment 10% with a guarantee letter, which costs 0.25% per month paid to the bank at the project start date. A performance guarantee letter of 10% will be submitted from contractor at the project begin. Invoices are submitted every month and will be paid a month later. Retention 10% and will be paid at the last invoice. Subcontractors: retention 10% will be paid at the last invoice, down payment 20%. Labor: labor expenses to be paid bi-weekly. Equipment: equipment expenses
Capital Budgeting Techniques Analyze the two independent projects, X and Y. Each project costs $10,000, and the firm’s required rate of return is 12%. The expected net cash flows are as follows: Outflows Inflows Projects Year 1 2 3 4 X -10,000 6,500 3,000 3,000 1,000 Y -10,000 3,500 3,500 3,500 5,500 Required: Calculate for each project: Payback Period IRR NPV PI Give your decision regarding acceptation and rejection of the project. Explain which criteria you based your decision upon and why?
Suppose a company has the following three project and limits it capital budget to $50,000. Project Present Value of Cash Initial Investment A. $40,000. $25,000B. 37,500. 25,000C. 70,000. 50,0001. Calculate the projects' NPVs.2. Calculate the projects' PIs.3. Which project (s) should the company choose? Why?
1. A) What are disadvantages of Payback Period method used in capital budgeting? B) A project has an initial cost of $1000 and $450 cash inflow each year for 4 years with a discount rate of 10%. What is its payback period? What is its discounted payback period?
Modified internal h. Payback period; discounted payback CAPITAL BUDGETING CRITERIA You must analyze two projects, X and Y. Each project costs $10,000, and the firm's WACC is 12%. The expected cash flows are as follows. ST-2 0. 1 2. 4 -$10,000 -$10,000 $3,000 $3,500 $1,000 $3,500 $3,000 Project X Project Y $6,500 $3,500 $3,500 Calculate each project's NPV, IRR, MIRR, payback, and discounted payback. b. Which project(s) should be accepted if they are independent? Which project(s) should be accepted if they are mutually exclusive? d. How might a change in the WACC produce a conflict between the NPV amd IRR rankings of the two projects? Would there be a conflict if WACC were 5%? (Hint: Plot the NPV profiles. The crossover rate is 6.21875%.) a. C. e. Why does the conflict exist?
Basic Capital Budgeting Techniques Answer each independent question, (a) through (e).a. Project A costs $5,000 and will generate annual after-tax net cash inflows of $1,800 for 5 years.What is the payback period (in years, rounded to 2 decimal places) for this investment under theassumption that the cash inflows occur evenly throughout the year?b. Project B costs $5,000 and will generate after-tax cash inflows of $500 in year 1, $1,200 in year2, $2,000 in year 3, $2,500 in year 4, and $2,000 in year 5. What is the payback period (in years,rounded to 2 decimal places) for this investment assuming that the cash inflows occur evenlythroughout the year?c. Project C costs $5,000 and will generate net cash inflows of $2,500 before taxes each year for 5years. The firm uses straight-line depreciation with no salvage value and is subject to a 25% taxrate. What is the payback period (in years, and rounded to 2 decimal places) under the assumptionthat all cash inflows occur evenly throughout the…
Given information on the following set of projects from a roadway agency, determine the Minimum Attractive Rate of Return (MARR) for this agency if the agency budget is 1.85 million. Assume n=25 years for all projects listed.
Most Company has an opportunity to invest in one of two new projects. Project Y requires a $350,000 investment for new machinery with a four-year life and no salvage value. Project Z requires a $350,000 investment for new machinery with a three-year life and no salvage value. The two projects yield the following predicted annual results. The company uses straight-line depreciation, and cash flows occur evenly throughout each year. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Project Y Project z $350,000 Sales Expenses Direct materials Direct labor Overhead including depreciation Selling and administrative expenses Total expenses $280,000 49,000 70,000 126,000 25,000 270,000 80,000 24,000 35,000 42,000 126,000 25,000 228,000 52,000 15,600 Pretax income Income taxes (30%) Net income $56,000 $ 36,400