Problem 2 ABM Enterprise would like to evaluate/analyze an investment proposal. Given the following: Investment amount - 450,000 (2022) Dividends / Revenue stream - 100,000 for the first year and an interval of 5,000 for the succeeding years Discount rate - 14% a. NPV for the perio 2023 through 2029; b. Total NPV using manual computation; c. Total NPV using the Excel function; and d. IRR rate.
Q: Southern Tours is considering acquiring Holiday Vacations. Management believes Holiday Vacations can...
A: maximum Southern Tours should pay today to acquire Holiday Vacations = present value of future cash ...
Q: orksheet Net worksheet Using the information provided, complete Figure 1.1, Seller Net Worksheet. Se...
A: Seller Net Worksheet Various issues to consider.
Q: If you save that money with interest rate of 10%, how much will it be after 20 years?
A: Future Value: It is the future worth of the present sum of money or stream of present annuity paymen...
Q: OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $501 million and ...
A: “Since you have posted a question with multiple sub-parts, we will solve first three subparts for yo...
Q: . QRW Corp. needs to replace an old machine with a new, more efficient model. The new machine being ...
A: The Net Present Value: The Net Present Value or NPV is one of the widely-used methods for assessing ...
Q: Suppose the stock price is $83 and the continuously compounded annual interest rate is 7%. If the 6-...
A: Stock price or spot rate is $83 6 month forward price is $85 To Find: Forward premium
Q: At the birth of his daughter, Mr Lucas Dalitso Zulu invested K10,000 at 6% p.a. compounded annually....
A: Future value can be calculated using FV (rate, nper, pmt, [Pv], [type]) Rate The interest rate Nper...
Q: A preferred stock will pay a dividend of $1 per quarter. If the annual return is 6.06%, what is the ...
A: Here, Dividend per Quarter is $1 Therefore, Dividend per year will be: =$1*4 =$4 Annual Return is 6....
Q: Which of the following would not be classified as a current asset? Prepaid expenses Plant, property ...
A: Current assets are those assets which are already in cash or can be converted into cash into short p...
Q: You have followed TSLA over the last 2 years, and have compiled the following price data for the mos...
A: Hi There, Thanks for posting the questions. As per our Q&A guidelines, must be answered only one...
Q: Mrs. Pores invested ₱150,000 in a bank that pays an 13% interest converted monthly. If her account b...
A: Invested amount is P150,000 Account balance today is P168,900 Interest rate is 13% converted quaterl...
Q: Albert Ang invested P88,000 at ABC Credit Union at 12% interest compounded quarterly. What is the ef...
A: Answer - The effective annual interest rate is the real return on a interest-paying investment when...
Q: An industrial plant bought a generator set for P90,000. Other expenses including installation amount...
A:
Q: You own a stock portfolio invested 33 percent in Stock Q, 20 percent in Stock R, 37 percent in Stock...
A: Stock Weight Beta Q 33% 1.02 R 20% 1.08 S 37% 1.48 T 10% 1.93
Q: How do I prepare the cash budget for the quarter ended March 31, 20X1?
A: A cash budget is a document created to aid in the management of a company's cash flow. A cash budget...
Q: (Cash conversion cycle) Sims Electric Corp. has been striving for the last five years to improve its...
A: Cash conversion cycle of a business organization ascertains the time period which a company takes to...
Q: Michael has a bank account that is worth $80,550. (a) Find the overall ROR if he had deposit...
A: a) Calculation of overall rate of return is calculated using the following formula: Compound annual ...
Q: why is profit maximization supposedly not the most important goal of a company
A: Profit Maximization: The process of raising the profit earning capacity of the business is known as ...
Q: You can earn $42 in interest on a $1,000 deposit for eight months. If the EAR is the same regardless...
A:
Q: A manual stamping machine currently valued at Rs. 1000/- is expected to last 2 years and costs Rs 40...
A: We need to find the present worth of costs for both machines. As manual machine's duration is 2 year...
Q: What is Bond A's interest rate?
A: Real Risk-Free Rate: It is the rate of return expected from a risk-less investment. It is computed b...
Q: Modern Artifacts can produce keepsakes that will be sold for $76 each. Non-depreciated fixed costs a...
A: Given, Initial investment $2940 Fixed cost $940 per year Sales price per unit $76 each
Q: Candy Company had sales of $320,000 and cost of goods sold of $112,000. What is the gross profit mar...
A: Gross profit margin helps in assessing how much the company has after paying all the costs which are...
Q: Mr. Bienvenido Bautista needs a fund of Php1,000,000 to renovate his house. To provide for this, he ...
A: It can be calculated using =NPER(rate,pmt,pv,[fv],[type]) Rate The interest rate for the loan. Nper...
Q: Capital One is advertising a 60-month, 6.61% APR motorcycle loan. If you need to borrow $12,000 to ...
A: Given Information : Annual interest rate = 6.61%Amount borrowed = $12,000 Number of months = 60
Q: Bob has $2,500 invested in a bank that pays 1% annually. How long will it take for his funds to doub...
A: Investment value (PV) = $2500 Future value (FV) = 2500*2 = $5000 Interest rate (r) = 1%
Q: Innovation Company is thinking about marketing a new software product. Upfront costs to market and d...
A: Initial Cost $ 49,70,000.00 Profit $ 11,40,000.00 Perpetuity cost $ 95,000.00 ...
Q: Your firm has the following income statement items: sales of $52,000,000; income tax of $1,880,000; ...
A: For the purpose of computing the cash flow from operations: 1. Any non-cash income or expense needs ...
Q: Jimmy has $212,810 accumulated in a 401K plan. The fund is earning a low, but safe, 3% per year. The...
A: Given, amount accumulated $212,810. Rate is 3% per year withdrawals are $23,000 each year
Q: A project requires an initial investment of $225,000 and is expected to generate the following net c...
A: Before investing in new projects or assets, profitability of the project is evaluated by using vario...
Q: You purchased a share of stock for Rs 250. One year later you received Rs 5 as dividend and sold the...
A: Holding period return is the total return earned over a period of time from holding an asset. It inc...
Q: t the end of the year? 1. 1099 B. Schedule C C. 1040 D. W2
A: There are income from savings that you must show in the income tax return form and for that separate...
Q: Navistar Electric issued 1000 debenture bonds 5 years ago with a face value of $5,000 each and a bon...
A: A Bond is an instrument that represents the loan that is made by the investor to the company and af...
Q: You won a lottery of $1,000,000. Office offered two options: the first one you can take it today a ...
A: The series of equal payment which is made over indefinite period of time is called as perpetuity. Th...
Q: How many years are needed for P40,000 to yield P13,756.66 if invested at 6% converted semi-annually ...
A: Given, Interest rate 6% compounded semi annually So, Interest rate per semi annual = 6%/2 = 3% ...
Q: Find the compound interest if $2000 is invested for 12 years at 8% compounded quarterly.
A: Future value = Present value(1 + Rate)^Time where, Present value = $2000 Rate = 8% / 4 = 2% Time = 1...
Q: Corporations often offer ________ to investors as some tangible evidence that the corporation is doi...
A: The firms get capital form different sources such as equity, debt and loans from any financial insti...
Q: Suppose a savings account pays 7% annual interest with interest compounded daily (assume there are 3...
A: Daily compounding Nominal rate= 7% Number of compounding periods = 365 Deposit = 2578 N = 3285 days ...
Q: Please view the following video before answering this question. Video Solution: 03.03-PROO4 Click he...
A: Data given: Par value = $10,000 Coupon rate =8% p.a. (payable quarterly) n=3 years Period = 3*4 = 12...
Q: One year ago, your company purchased a machine used in manufacturing for $115,000. You have learned ...
A: Incremental Analysis: Incremental analysis is a technique that is used to compare two projects by ta...
Q: Bob has $2,500 invested in a bank that pays 1% annually. How long will it take for his funds to doub...
A: Given, 2500 invested now Amount doubled = 2500 + 2500 = 5000 So, Maturity Value = 5000
Q: Interest rates are important to financial institutions since an interest rate increase will decrease...
A: The interest rate is the amount charged by a lender to a borrower for the use of assets on top of th...
Q: The formula below tells us how to obtain the maturity value on a simple discount loan if we are give...
A: Simple discount rate = 7.56% How many years for debt to double? Assuming Debt = 100 Future Value = 2...
Q: You own a portfolio that is 23 percent invested in Stock X, 38 percent in Stock Y, and 39 percent in...
A: Stock Weight Return X 23% 11% Y 38% 14% Z 39% 16%
Q: Amount Financed Number of Payments APR Table Factor Finance Charge Monthly Payment $600 18 17% $ $ ...
A: Borrowings are the liability of the company which is used to finance the requirement of the funds. T...
Q: Consider the following income statement and other information: Luther Corporation Consolidated ...
A: Earnings per share = Net income/Number of shares outstanding
Q: Ted Williams made deposits of $500 at the end of each year for eight years. The rate is 8% compounde...
A: Annual deposit (P) = $500 Interest rate (r) = 8% Period (n) = 8 Years
Q: A lender requires PMI that is 0.8% of the loan amount of $490,000. How much (in dollars) will this a...
A: A loan's PMI or Private mortgage insurance is a kind of mortgage insurance that is used by lenders w...
Q: A $40,000 loan at 4% dated June 10 is due to be paid on October 11. The amount of interest is (assum...
A: Ordinary interest = Principle * Interest rate * Number of days of loan taken / 360 days in a year
Q: Which of the following statements is false? A) In bankruptcy, management is given the opportunity t...
A:
Problem 2
ABM Enterprise would like to evaluate/analyze an investment proposal.
Given the following:
Investment amount - 450,000 (2022)
Dividends / Revenue stream - 100,000 for the first year and an interval of 5,000 for the
succeeding years
Discount rate - 14%
a. NPV for the perio 2023 through 2029;
b. Total NPV using manual computation;
c. Total NPV using the Excel function; and
d.
Step by step
Solved in 5 steps with 4 images
- 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…Cash Payback Period, Net Present Value Method, and Analysis Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project are as follows: Plant Expansion Retail Store Expansion Year 1 2 3 4 5 Total Year 1 2 Each project requires an investment of $294,000. A rate of 15% has been selected for the net present value analysis. Present Value of $1 at Compound Interest 6% 10% 12% 15% 20% 0.893 0.870 0.833 0.797 0.756 0.694 3 4 5 $162,000 132,000 114,000 103,000 33,000 $544,000 6 7 8 9 10 Required: 0.909 0.826 $135,000 159,000 109,000 76,000 65,000 $544,000 0.943 0.890 0.840 0.751 0.792 0.683 0.747 0.621 0.705 0.564 0.665 0.627 0.592 0.558 0.712 0.658 0.636 0.572 0.567 0.497 0.507 0.432 0.513 0.452 0.376 0.467 0.404 0.327 0.424 0.361 0.284 0.386 0.322 0.247 1a. Compute the cash payback period for each project. Cash Payback Period 0.579 0.482 0.402 0.335 0.279 0.233 0.194 0.162 Plant Expansion Retail Store Expansion 1b. Compute the net present value.…Calculate the APR of the following investment, entered as a percentage (Example: if your answer is 14.5%, enter 14.5 and not 0.145) Year Number Cashflow 0 -11000 1 3000 2 3500 3 2900 4 2800
- 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 equitiesCalculate the EAR of the following investment, entered as a percentage (Example: if your answer is 0.145, enter 14.5) Year Number Cashflow 0 -11400 1 3500 2 3000 3 3100 4 2800 Your Answer:Using the following information, calculate the RAROC. •Risk-Adjusted Return: $80,000•Loan Amount: $3,000,000•Capital Requirement: 10%•Capital Ratio: 75% a) 28.75% b) 33.33% c) 35.56% d) 38.25%
- Profitability index. Given the discount rate and the future cash flow of each project listed in the following table, . use the Pl to determine which projects the company should accept. What is the Pl of project A? i Data Table (Round to two decimal places.) (Click on the following icon o in order to copy its contents into a spreadsheet.) Cash Flow Project A -%241,900,000 $150,000 $350,000 Project B Year 0 $2,300,000 $1,150,000 $950 000 $750,000 $550,000 Year 1 Year 2 Year 3 $550,000 Year 4 $750,000 $950,000 4% Year 5 $350.000 Discount rate 18% Print DoneDaymore plc is currently considering three investment opportunities. The following is the details of the investments:-Project A:-1. initial outlay $80m2. Future net inflows Year 1: $190mYear 2: $10mProject B:-1. initial outlay $140m2. Future net inflows Year 1: $180mYear 2: $120mProject C:-1. initial outlay $90m2. Future net inflows Year 1: $10mYear 2: $220mThe company has a capital budget that is restricted in the year of the investment and it will not be possible to undertake all three projects in full. The investment opportunities are independent of one another and each project is divisible (that is, it is possible to undertake part of an investment and to receive a pro-rata return). The cost of capital of the company is 12% and the company uses the net present value method of investment appraisal.Required:Calculate and determine the ranking of the three investment opportunities? (The ranking for the first choice, second choice, and third choice is 1, 2, and 3 respectively). Show…Please help answer From Question 3.1 to 3.5 REQUIREDStudy the information provided below and calculate the following:3.1 Payback Period of Project A (answer expressed in years, months and days). 3.2 Accounting Rate of Return (on average investment) of Project B (answer expressed totwo decimal places).3.3 Net Present Value of both projets (amounts rounded off to the nearest Rand). 3.4 Benefit Cost Ratio of Project A (answer expressed to three decimal places). 3.5 Internal Rate of Return of Project B (answer expressed to two decimal places). INFORMATIONThe following information relates to two possible capital expenditure projects being considered by EdamLtd. Because of capital rationing, only one project can be accepted.Project A Project BInitial cost R800 000 R800 000Expected useful life 5 years 5 yearsAverage annual profit R80 000 R80 000Expected net cash inflows: R RYear 1 240 000 240 000Year 2 260 000 240 000Year 3 280 000 240 000Year 4 220 000 240 000Year 5 200 000 240 000The…
- There are two proposals of investment, the estimated financial data related to these proposal as following Proposal A Proposal B Initial Investment $350000 $180000 Cash Inflow: year 1 $100000 $50000 Year 2 $120000 $50000 Year 3 $150000 $50000 Year 4 $90000 $50000 Year 5 $30000 $50000 Required Rate on return (RRR) 10% 10% All payment of inflows is at the end of accounting period while investment is paid at beginning of period, straight line method of depreciation is used Answer Below Questions Profitability index of Proposal B Answer 1 Payback period in years and months of Proposal B Answer 2 Rank the proposals based on Lowest Payback Period Answer 3 Profitability index of Proposal A Answer 4 Simple Rate on Return of Proposal A Answer 5 Payback period in years and months of proposal A Answer 6 Internal Rate on Return of Proposal B (IRR) Answer 7 PV…EconomicS 2. Referring to the given data in 6.7/317 at the end of Chapter 6 (Engineering Economy by Sullivan et al), select the best alternative using: (a) PW (b) AW © FW (d) IRR 6-7. Three mutually exclusive design alternatives are being considered. The estimated cash flows for each alternative are given next. The MARR is 20% per year. At the conclusion of the useful life, the investment will be sold. A в $28,000 $55,000 $40,000 Annual expenses $15,000 $13,000 $22,000 Annual revenues $23,000 $28,000 $32,000 $6,000 $8,000 $10,000 Investment cost Market value Useful life 10 years 10 years 10 years 26.4% 24.7% 22.4% IRR A decision-maker can select one of these alternatives or decide to select none of them. Make a recommendation using the PW method. (6.4)b) Following data relate to five independent investment projects : Initial Outlay Projects P ORST 1,000,000 240,000 184,000 11,500 80,000 Annual Cash Inflows Life in Years 250,000 24,000 30,000 4,000 12,000 8 15 20 5 10 Page 2 of 3 Assume a 10% required rate of return and a 50% tax rate. Rank these five investment projects according to each of the following criteria: (i) Pay-back Period. (ii) Accounting Rate of Return. (iii) Net Present Value Index. (iv) Internal Rate of Return.
