Discount rate for project = corporate discount rate + Inflation
= 15%+10% = 25%
1.a) NPV Formula:
,
where NPV = Net present value
CF = cash flows
r = required rate of return= 25%
n = time period = 1,2,3,4
Time | 0 | 1 | 2 | 3 | 4 |
Cost | -450000 | ||||
Shipping | -100000 | ||||
Sales | 600000 | 600000 | 600000 | 600000 | |
Supplies cost | -250000 | -250000 | -250000 | -250000 | |
Labour fixed cost | -150000 | -150000 | -150000 | -150000 | |
Residual Value | 50000 | ||||
Total Cash flows | -550000 | 200000 | 200000 | 200000 | 250000 |
NPV @25% | -57200.00 |
1.b) Payback period by interpolation:
0 | 1 | 2 | 3 | 4 | |
Total Cash flows | -550000 | 200000 | 200000 | 200000 | 250000 |
Fraction of Initial cash outflow | 0.36363636 | 0.36363636 | 0.36363636 | 0.45454545 | |
Cumulative Fraction | 0.36363636 | 0.72727273 | 1.09090909 | 1.54545455 | |
Payback period = 2 + (1-0.7272)/(1.0909-0.7272) | 2.750068738 |
1)c) Profitability Index = Present value of future cash flows / initial investment = -57200/-550000 = 0.104
1)d) Reject the proposal. The NPV is negative and the Profitability
index is less than 1. This indicates that it is a loss making
project and will erode firm value.
please type answer please be detailed no fluff please stay on the subject Sonogram equipment purchase...
please answer all questions
from now to purchase electric landscaping equipment. If the estimated cost is $250,000, how much should the college set aside each year if the funds earn 9% per year? Problem 3 Create an amortization table for a 3 year loan of $19,000 at 4.9% nominal interest compounded monthly. The table should include the date, remaining balance, pay period, interest payed during the payment period, principal payed in the payment period, and cumulative interest payed.
Please solve the following problem WITHOUT USING
EXCEL. Please type your answer.
Roberto Inc. is a manufacturing company. The company has always followed their ideal capital structure which the management insists is 40% debt and 60% equity capital. The company can issue bonds for 9% coupon rate with 22 years to maturity. The interest is paid semi-annually. The bonds can be issued with a price of $835.42 today. Roberto's marginal tax rate is 40%. For cost of equity, the company...
Cost Analysis: The Purchase of Health Care Equipment Team Project An equipment acquisition proposal is being considered by a large healthcare organization, XYZ Health Care. The array machine will enable the hospital to perform autoimmunity tests (for immunoglobulins G, M, and A and complements C3 and C4) in-house rather than sending them to a reference laboratory. Test turnaround time is expected to decrease by 2 days. The array machine costs $50,000, with a useful life of 5 years. The depreciation...
help please!
Statement of cash flows-direct method applied to PR 13-1A Instructions Labels and Amount Descriptions Statement of Cash Flows Instructions Dec. 31, 2043 Dec. 31,2072 Assets Cash $155,000.00 $150,000.00 Accounts receivable (net) 450,000.00 400,000.00 Inventories 770,000.00 750,000.00 100,000.00 Investments 0.00 7 Land 500,000.00 0.00 8 Equipment 1,400,000.00 9 Accumulated depreciation equipment (600,000.00) $2,675,000.00 1,200,000.00 (500,000.00) $2,100,000.00 10 Total assets Liabilities and Stockholders' Equity 12 Accounts payable (merchandise creditors) $340,000.00 $300,000.00 Accrued expenses payable (operating expenses) 50,000.00 45,000.00 30,000.00 14...
please use excel to answer the questions and show all
outputs
E3) The Erley Equipment Company purchased a machine 5 years ago at a cost of $100,000. The machine had an expected life of 10 years at the time of purchase, and an expected salvage value of $10,000 at the end of the 10 years. It is being depreciated by the straight line method toward a salvage value of $10,000, or by $9,000 per year. A new machine can be...
***PLEASE ANSWER ALL QUESTIONS IN DETAIL, SHOWING ALL WORK AND CALCULATIONS FOR A THUMBS UP! THANKS A TON! Buy vs Lease Angelo Rossi opened his little “upscale” Italian restaurant almost 25 years ago in the heart of New York City. His specialty was the freshly baked bread oozing with homemade garlic butter and of course, the delicious varieties of pasta and lasagna. The ambience and aroma were simply out of this world and kept bringing the customers back for more....
*****PLEASE ONLY ANSWER PART C****** A real estate investor has the opportunity to purchase land currently zoned as residential. If the county board approves a request to rezone the property as commercial within the next year, the investor will be able to lease the land to a large discount firm that wants to open a new store on the property. However, if the zoning change is not approved, the investor will have to sell the property at a loss. Profits...
Please explain your answer as well, thank you!
LOS 17 Cash receipts, disbursements and summary budgets Veronica's Cakes cooks and distributes cakes for every imaginable occasion. Veronica started the company in her house three years ago and has been surprised at her success. She is considering expanding her business and needs to prepare cash budgeting information to present to Westpac Bank to secure a loan. Veronica is not an accountant, so she has asked you to help her to prepare...
Please explain your answer as well, thank you!
LOS 17 Cash receipts, disbursements and summary budgets Veronica's Cakes cooks and distributes cakes for every imaginable occasion. Veronica started the company in her house three years ago and has been surprised at her success. She is considering expanding her business and needs to prepare cash budgeting information to present to Westpac Bank to secure a loan. Veronica is not an accountant, so she has asked you to help her to prepare...
Please answer all three. Thank you.
Bailey Sheppard Corp. ("BSC") manufactures musical equipment and is evaluating the economics of expanding its manufacturing facility to enable it to take on a new business customer contract for the next 4 years. Last year, the company paid Target Research LLC $35,000 to do a marketing research study for its product lines. The current expansion scenario would have total construction costs of $1.3 million and it would take about 50 days to complete lie.,...