02

Required information [The following information applies to the questions displayed below.] The following capital expenditure projects have been proposed for management's consideration at Scott Inc. for the upcoming budget year: Use Table 6-4 and Table 6-5. (Use appropriate factor(s) from the tables provided. Round the PV factors to 4 decimals.) Project Year (s) D E $ (25,000) 5,000 5,000 5,000 5,000 5,000 5,000 $ 1,081 $ (25,000) $ (50,000) $ (50,000) 5,000 10,000 15,000 20,000 25,000 Initial investment $(100,000) 30,000 30,000 Amount of net cash return 16,000 16,000 16,000 16,000 16,000 10,000 15,000 10,000 10,000 6,000 15,000 15,000 5 Per year 6-10 15,000 NPV (14% discount rate) $ 2,942 Present value ratio 1.04 b. Calculate the present value ratio for projects B, C, D, and E. (Round your answers to 2 decimal places.) Project Present Value Ratio B D E

Simple Investment Allocation Case: This year, 2022 ABM Company selected your team to manage their allotted budget amounting to 10 million pesos for investment diversification portfolio. Your team was assigned to handle the said account. What would you choose? Other investment assets or Alternatives to fixed income and equities

Video Excel Online Structured Activity: Capital budgeting criteria A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 + Project A -$300 -$387 Project B -$405 $133 -$193 -$100 $133 $133 $600 $133 $600 $133 $850 -$180 $133 $0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet a. What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations. Project A: $ 162.48 Project B: $ b. What is each project's IRR? Round your answer to two decimal places. Project A: 18.10 % Project B: %

NPV Analysis; Sensitivity Analysis; Data Tables in Excel This assignment is designed tointroduce you to the preparation of both a one-variable and a two-variable Data Table in Excel. Suchtables are useful for conducting and reporting the results of a series of what-if analyses. Assume thata hypothetical 5-year investment would require a net investment outlay of $350,000 and would haveannual (after-tax) cash inflows of $100,000. Assume, too, that the company considering this investment uses a 10% discount rate (weighted-average cost of capital) for present-value calculations.Required1. Consult the specified online help file (Microsoft website) regarding the preparation of Data Tables. (Seefootnote 27.)2. Prepare a one-variable Data Table where you depict the NPV of the proposed investment at each of thefollowing discount rates: 8% to 12%, in increments of 0.5%. Round your answers to nearest whole dollar. 3. Prepare a two-variable Data Table where, in addition to the 10 discount rates…

please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)       QUESTION 2   In the late June of each year, BOS Global Ltd prepares a cash budget for the next 6 months. The entity’s management wishes to prepare a cash budget in order to assess its likely requirements for short-term funds. Actual sales for May, and estimated sales for June, and for the next 7 months are as follows: Months Sales Revenues (Actual and Estimates) [GHS]   Months Sales Revenues (Actual and Estimates) [GHS] May 20,000   September 50,000 June 28,000   October 94,000 July 24,000   November 74,000 August 26,000   December 52,000       January 40,000     Approximately 25 per cent of sales are for cash and 75 per cent are on credit. Past experience has shown that two-third of all credit sales are collected in the month immediately following the month…

Simple Investment Allocation Case: This year, 2022 ABM Company selected your team to manage their allotted budget amounting to 10 million pesos for investment diversification portfolio. Your team was assigned to handle the said account. Question: How would you allocate funds?

ne NPV, with rankings Botany Bay, Inc., a maker of casual clothing, is considering four projects shown in the following table, Because of past financial difficulties, ptions the company has a high cost of capital at 14.4%. a. Calculate the NPV of each project, using a cost of capital of 14.4%. b. Rank acceptable projects by NPV. c. Calculate the IRR of each project and use it to determine the highest cost of capital at which all of the projects would be acceptable. a. Calculate the NPV of each project, using a cost of capital of 14.4%. The NPV of project A is $ (Round to the nearest cent.) Is project A acceptable? (Select the best answer below.) O A. No O B. Yes The NPV of project B is $ (Round to the nearest cent.) la nreinnt Danontabl-2/0lest the hant an nr hale Click to select your answer(s). P Type here to search

4. What is the total project budget in this time-phased budget? Activity August September October RFP Analysis Design Coding Testing Training Roll-Out July 31,000 3,000 A) $210,000 B) $193,000 C) $184,500 D) $178,300 15,000 23,000 34,000 46,000 10,000 15,000 November 15,000 18,000

Required information Skip to question   [The following information applies to the questions displayed below.]   Endless Mountain Company manufactures a single product that is popular with outdoor recreation enthusiasts. The company sells its product to retailers throughout the northeastern quadrant of the United States. It is in the process of creating a master budget for 2022 and reports a balance sheet at December 31, 2021 as follows:   Endless Mountain Company Balance Sheet December 31, 2021 Assets Current assets:             Cash $ 46,200         Accounts receivable (net)   260,000         Raw materials inventory (4,500 yards)   11,250         Finished goods inventory (1,500 units)   32,250         Total current assets       $ 349,700   Plant and equipment:             Buildings and equipment   900,000         Accumulated depreciation   (292,000 )       Plant and equipment, net         608,000   Total assets       $ 957,700   Liabilities and…

A project has been defined that consist of 13 activities for which the estimated cost and duration have been defined (TABLE). Afterfour-andahalf monthfthe activates A, B, D. E, G are completed and Fis one half complete nd (H) is three -fourth complete and (C) is half complete The incurred cost to date is 1720009 Apply your knowledge of camed value to calculate the status of this project in terms of the schedule and the budger? Activity 中 Cost 100000 25600 500000 4S000 150000 29000 180000 84000 840000 700000 470000 Jan Feb Mar May Jun H. 45000

Required information Learning Objective 11-04 Calculate the periodic amortization of an intangible asset. (The following information applies to the questions displayed below.] The allocation process for intangible assets is called amortization. For an intangible asset with a finite useful life, the capitalized cost less any estimated residual value must be allocated to periods in which the asset is expected to contribute to the company's revenue-generating activities. An intangible asset that is determined to have an indefinite useful life is not subject to periodic amortization. Goodwill is perhaps the most typical intangible asset with an indefinite useful life. Software development

1. What do you understand by a project budget? Please outline the steps needed to prepare a project budget and indicate the types of costs associated with budgets.  2. Prepare a multi-year budget for a project for a period of 3 years (2020-2022) in an Excel worksheet incorporating the following information.  Please upload your excel document. 3. Please prepare a consolidated budget pivot table in Excel by budget class and year.  Please upload your excel document. Budget Class – Staff Costs • Salary of the Project Manager @ USD 5,000 per month. • Salary of the Admin Finance Officer @ USD 3,500 per month. • Salary of Admin. & Finance Assistant @USD 1,000 per month • Salary of Driver @USD 500 per month Budget Class – Equipment & Furniture Cost of the office equipment and furniture required for the project is USD 30,000 for three years to be procured during the 1st year of the project. Budget Class – Operating Costs (training) Two trainers are required for each training. Each…

You are part of a consulting team working with a well-established technology company that is preparing its long-term financial plan. The company is keen on making strategic decisions for the coming decade. The plan must encompass various aspects, including investments in non-current assets, research and development, marketing, product development activities, capital structure, and financing sources. Which of the following elements should be considered in this comprehensive plan? Select one: Short-term financial goals for the next financial year Quarterly budgetary adjustments Immediate cash flow management strategies Proposed investments in non-current assets The company's daily operational expenses

CURRENT PROJECT BUDGET : R273 000 Task Completion date scheduled Budgeted Amount (BCWP) Cash Flow Actual Cost (acwp) Cost Variance(CVAR/CV) Task a 20/01/2021 60000 ??? 66000 -6000 Task b 15/02/2021 ??? 48000 48000 -3000 Task c 24/03/3021 78000 ??? 78000 ??? Task d 31/03/2021 90000 84000 ??? 6000 TOTAL 31/03/2021 ??? ??? ??? ??? Study the following project-spending plan and calculate the following (indicate the actual calculations in full)1. Cash Flow for Task b

me IRR-Mutually exclusive projects Bell Manufacturing is attempting to choose the better of two mutually exclusive projects for expanding the firm's warehouse capacity. The relevant cash flows for the projects are shown in the following table: . The firm's cost of capital is 15%. Options a. Calculate the IRR for each of the projects. Assess the acceptability of each project on the basis of the IRRS. b. Which project is preferred? a. The internal rate of return (IRR) of project X is %. (Round to two decimal places.) Is project X acceptable on the basis of IRR? (Select the best answer below.) No O Yes The internal rate of return (IRR) of project Y is %. (Round to two decimal places.) Is project Y acceptable on the basis of IRR? (Select the best answer below.) O Yes Click to select your answer(s). O Type here to search

All techniques with NPV profile-Mutually exclusive projects Projects A and B, of equal risk, are alternatives for expanding Rosa Company's capacity. The firm's cost of capital is 12%. The cash flows for each project are shown in the following table: a. Calculate each project's payback period. b. Calculate the net present value (NPV) for each project. c. Calculate the internal rate of return (IRR) for each project. d. Indicate which project you would recommend. GICKER a. The payback period of project A is years. (Round to two decimal places.) The payback period of project B is years. (Round to two decimal places.) b. The NPV of project A is $. (Round to the nearest cent.) The NPV of project B is $. (Round to the nearest cent.) c. The IRR of project A is%. (Round to two decimal places.) The IRR of project B is%. (Round to two decimal places.) d. Which project will you recommend? (Select the best answer below.) OA. Project B OB. Project A

The master budget of Levis Limited for 2020 has largely been completed. All that remains isthe preparation of the statement of financial position as at 31 December 2020. Themanagement of Levis Limited is also in the process of identifying investment opportunities for2021. Two projects have been identified and your assistance is required in undertakingcapital investment appraisal. QUESTION 1 Use the following information to prepare the Pro Forma Statement of Financial Position ofLevis Limited as at 31 December 2020. Where applicable, round off amounts to the nearestRand.INFORMATION■ The sales of Levis Limited for 2019 amounted to R6 000 000. The sales for 2020 areexpected to increase by R2 000 000. All sales are on credit.■ Accounts payable must be calculated using the percentage-of-sales method.■ Accounts receivable is based on a collection period of 30 days.■ The following ratios are forecast for 2020:Gross margin 25%(Net) Profit margin 10%■ All purchases of inventory are on credit.…

Research and development cost for Headway Corporation for the year ended December 31, 2024:Project A. Expected total revenues P7,000,000, starting in early 2023. Expected total costs,will be P5,000,000. Costs incurred to date, all in 2014, are P2,200,000.Project B. Expected total revenues P6,000,000. Costs incurred to date are P3,500,000. Expected total costs are P4,500,000. The commencement of commercial sales is uncertain due to problems in raising funds to cover the final development costs.Project C. Expected total revenues, P3,500,000 with P1,000,000 of revenue already earned in 2024. Total development costs incurred, all in 2024, were P3,800,000.Research projects. Total costs spend in 2024 were P I,500,000.What amount of development cost should Headway Company capitalize in 2024?   a. 2,200,000 b. 5,700,000 c. 6,000,000 d. 7,500,000

Understanding Relationships, Master Budget, Comprehensive Review Optima Company is a high-technology organization that produces a mass-storage system. The design of Optima's system is unique and represents a breakthrough in the industry. The units Optima produces combine positive features of both compact and hard disks. The company is completing its fifth year of operations and is preparing to build its master budget for the coming year (20X1). The budget will detail each quarter's activity and the activity for the year in total. The master budget will be based on the following information: Fourth-quarter sales for 20X0 are 55,000 units. Unit sales by quarter (for 20X1) are projected as follows: First quarter 65,000     Second quarter 70,000     Third quarter 75,000     Fourth quarter 90,000     The selling price is $400 per unit. All sales are credit sales. Optima collects 85% of all sales within the quarter in which they are realized; the other 15% is collected in the…

Romanos Construction is analyzing its capital expenditure proposals for the purchase of equipment in the coming year. The capital budget is limited to $5,000,000 for the year. Laura Berenstein​, staff analyst at Romanos​, is preparing an analysis of the three projects under consideration by Chester Romanos​, the​ company's owner.   Data Table   A B C D 1   Project A Project B Project C 2 Projected cash outflow       3 Net initial investment $3,000,000 $2,100,000 $3,000,000 4 Projected cash inflows       5 Year 1 $1,200,000 $1,200,000 $1,700,000 6 Year 2 1,200,000 600,000 1,700,000 7 Year 3 1,200,000 500,000 200,000 8 Year 4 1,200,000   100,000 9 Required rate of return 10% 10% 10%       1. Because the​ company's cash is​ limited, Romanos thinks the payback method should be used to choose between the capital budgeting projects.   a. What are the…

PROJECT A    PROJECT BInitial Outlay    -60,000    -80,000Inflow year 1    17,000    18,000Inflow year 2    17,000    18,000Inflow year 3    17,000    18,000Inflow year 4    17,000    18,000Inflow year 5    17,000    18,000Inflow year 6    17,000    18,000

arning X + tps://ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=5933142288413647560152243&eISBN=97813379 CENGAGE | MINDTAP 11: Assignment - The Basics of Capital Budgeting Blue Llama Mining Company is evaluating a proposed capital budgeting project (project Sigma) that will require an initial investment of $800,000. Blue Llama Mining Company has been basing capital budgeting decisions on a project's NPV; however, its new CFO wants to start using the IRR method for capital budgeting decisions. The CFO says that the IRR is a better method because returns in percentage form are easier to understand and compare to required returns. Blue Llama Mining Company's WACC is 8%, and project Sigma has the same risk as the firm's average project. The project is expected to generate the following net cash flows: Year Year 1 Year 2 Year 3 Year 4 Cash Flow $350,000 $475,000 $425,000 $500,000 Which of the following is the correct calculation of project Sigma's IRR? 34.38% 38.20% 42.02% O 36.29%

equired information Skip to question   [The following information applies to the questions displayed below.]   Endless Mountain Company manufactures a single product that is popular with outdoor recreation enthusiasts. The company sells its product to retailers throughout the northeastern quadrant of the United States. It is in the process of creating a master budget for 2022 and reports a balance sheet at December 31, 2021 as follows:   Endless Mountain Company Balance Sheet December 31, 2021 Assets Current assets:             Cash $ 46,200         Accounts receivable (net)   260,000         Raw materials inventory (4,500 yards)   11,250         Finished goods inventory (1,500 units)   32,250         Total current assets       $ 349,700   Plant and equipment:             Buildings and equipment   900,000         Accumulated depreciation   (292,000 )       Plant and equipment, net         608,000   Total assets       $ 957,700   Liabilities and…

Table 1: The Planned Value of Work Done Schedule Jan Feb March Project A Project B Project C Project D 60,000 100,000 80,000 120,000 100,000 80,000 80,000 120,000 120,000 120,000 70,000 100,000 April 120,000 140,000 90,000 120,000 Мay 200,000 140,000 100,000 150,000 Based on the data obtained from each project, you have found out the value of work done on the 31st of March, which is shown in Table 2 below. Table 2: The Actual Value of Work Done and Direct Cost Incurred as of the 31st of March Project Actual Value of Work Done 300,000 250,000 250,000 280,000 Direct Cost Incurred A 220,000 180,000 200,000 240,000 Each project is supposed to contribute 10% profit and 8% orerhead to the compoany. You are requested to present to the company the turnorer as of the 31st of march. Prepare your answenr by answering the following que'stions. a) Calculate the planned ralue of work done, the total planned orerhead and the total profit contribution from all the. projects as of the 31st of March. b)…

BUS 203: INTRODUCTION TO COST AND MANAGEMENT ACCOUNTING PROJECT: CASH BUDGETING ASSOCIATE DEGREE YEAR 2: SEMESTER 1 (2020/21)Ronstadt Limited’s budget for the four months from January to April includes the following data:1. MonthSalesMaterialsWagesOverheads $000$000$000$000January615115.030360February636120.033390March690135.036420April684130.040425 2. One-third of sales revenue is received one month after sale and the remainder is received two months after sale. The sales in the previous two months were: November $600 000; December $540 000.3. One-quarter of purchases of materials are paid for in the month of purchase. The remainder are paid for two months later. Purchases in the previous two months were: November $108 000; December $106 000.4. Two-thirds of the wages are paid in the month in which they are earned, and the balance is paid in the following month. The wages for the previous December amounted to $30 000.5. One-half of the overhead expenditure is paid in the month in…

EXERCISE 3: CASH INFLOWS AND CASH OUTFLOWS With the following capital budgetng elements, identify the cash outflows and cash inflows that you would use to judge the attractiveness of a project by using the time- value-of money yardstıcks capital assets ($1.5 million), working capital in year 1 ($500,000) and year 2 ($200,000), salaries ($140,000), working capital loan ($190,000). residual value at the end of the 11th year ($1 million), profit for the years 1 to 10 ($300,000), mortgage ($1.1 million), non-cash expense ($50,000), revenue ($300,000), and sunk costs ($100,000). The project's lifespan is 10 years and the cost of capital is 8%.

Prepare a multi-year budget for a project for a period of 3 years (2020-2022) in an Excel worksheet incorporating the following information: Budget Class – Staff Costs • Salary of the Project Manager @ USD 5,000 per month. • Salary of the Admin Finance Officer @ USD 3,500 per month. • Salary of Admin. & Finance Assistant @USD 1,000 per month • Salary of Driver @USD 500 per month Budget Class – Equipment & Furniture Cost of the office equipment and furniture required for the project is USD 30,000 for three years to be procured during the 1st year of the project. Budget Class – Operating Costs (training) Two trainers are required for each training. Each training lasts for 5 days. The total number of participants for each training is 30. • DSA/ ticket cost of each participant @ USD1, 000 per training. • Total number of 5-day trainings planned for each year is 4. • Fee for Trainer @ USD 2,000 per training. • Cost of logistic arrangements for each training @ USD 10,000. In addition…

"Management Decision Analysis" 1. Discounted cash flow and budget cut analysis for a long lasting institute. A famous university was planning to prepare a ten-year continuous expenditure as a necessary investment for the renovation of the faculty buildings, i.e., 800 million Yuan per year in the next ten years are required for an extra expenditure beside all other needs of operations of the university. The project committee were considering a budget cut from the "current" annual budget of 7 billion per year. What could be an adequate rate of budget cut that you should want to suggest? Discuss about the influence of the interest rate used in the computation. Requirement: Write a VBA function "AnnuityFactor" to compute annuity factor to be used in the analysis, for skill enhancement

Capital Budgeting   Assume you are evaluating two mutually exclusive projects, the cash flows of which appear below and that your company uses a cost of capital of 13% to evaluate projects such as these.     Time Project A Cash Flows Project B Cash Flows 0 -$46,800 -$63,600 1 -21,600 20,400 2 43,200 20,400 3 43,200 20,400 4 43,200 20,400 5 -28,800 20,400     Sketch the NPV profile for projects A & B.