A local university has initiated a logo-licensing program with the clothier Holister, Inc. Estimated fees (revenues) are $20,000 for the first year with uniform increase to a total of $600,000 pesos by the end of year 9. What are the gradient and cash flow diagram?

A local university has initiated a logo-licensing program with the clothier Holister, Inc. Estimated fees (revenues) are $20,000 for the first year with uniform increase to a total of $600,000 pesos by the end of year 9. What are the gradient and cash flow diagram?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 15M

See similar textbooks

Similar questions

EXAMPLE 2.8 A local university has initiated a logo-licensing program with the clothier Holister, Inc. Esti- mated fees (revenues) are $80,000 for the first year with uniform increases to a total of $200,000 by the end of year 9. Determine the gradient and construct a cash flow diagram that identifies the base amount and the gradient series.
A local university has initiated a logo-licensing program with the clothier Holister, Inc. Estimated fees (revenues) are₱4,240,000.00 for the first year with uniform increases to a total of ₱10,600,000.00 by the end of year 9. Determine the gradient and construct a cash flow diagram that identifies the base amount and the gradient series.
The XYZ customer service branch maintains a disbursement account which is funded by the main office. The branch needs funds for daily disbursements of P40,000 and a minimum balance of P20,000. The cost to transfer funds from the main office to the branch averages P300. The return on money marketable securities is 5%. If the entity uses a 250-day year for financial analysis, how much is the optimal cash amount to be requested by the branch each time?
Harrison, Inc. is considering two investment opportunities. Each investment costs $7,000 and will provide the same total future cash inflows. The schedule of estimated cash receipts for each investment follows (assume cash is received at year-end): 16. 17. b. C. Year 1 Year 2 Year 3 Year 4 Total d. Which investment should Harrison choose assuming all other variables for the two investments are the same? a. Investment 1 $3,000 2,500 2,000 1,500 $9,000 Investment 2 $1,000 2,000 3,000 3,000 $9,000 Harrison should be indifferent between the two investments because they provide the same total cash inflows. Harrison should choose Investment I because of the time value of money. Harrison should be indifferent between the two investments because the initial cash outflow is the same. Harrison should choose Investment II because it generates larger cash inflows at the end of the investment's useful life. C. $926 d. $7,227 Assuming an 8% minimum rate of return, what is the net present value of…
Topic: Gradients General Direction: Solve using Given-Required-Solution format. DO NOT USE EXCEL. Provide a Cash Flow Diagram (CFD). Use the formula given. Three local government units in Metro Manila have agreed to pool their resources from taxes for the construction of a major road connecting their areas. It is estimated that an amount of P500,000 is to be deposited at the end of the year into a shared account for the first phase of theproject which will last 9 years after the initial deposit has been made. The deposit will increase by P100,000 per year after the initial deposit up until the lifetime of the project. Assume 5% annual interest rate. Determine:(a) Total present worth of the deposits(b) Construct the equivalent cash flow diagram
The capital investment committee of Ellis Transport and Storage Inc. is considering two investment projects. The estimated income from operations and net cash flows from each investment are as follows: Warehouse Tracking Technology Year Income fromOperations Net CashFlow Income fromOperations Net CashFlow 1 $62,000 $200,000 $130,000 $320,000 2 62,000 200,000 99,000 270,000 3 62,000 200,000 50,000 190,000 4 62,000 200,000 22,000 130,000 5 62,000 200,000 9,000 90,000 Total $310,000 $1,000,000 $310,000 $1,000,000 Each project requires an investment of $620,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 15% for purposes of the net present value analysis. Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792…
From Part A above, assume that the bank decided to give a loan of $ 59 million to Nivea Corporation (recorded for the initial year). Nivea-Corporation invested the amount in a project and generated the following sequence of cash flows over six years: Year Cash Flow ($ million) 0 -59 1 4 2 5 3 6 4 7.33 5 8 6 8.25 Calculate the Net Present Value (NPV) and the Profitability Index (PI) over the six years. Assume discount rate 17% This project does not end after the sixth year but instead will generate cash flows far into the future. Estimate the project’s terminal value, assuming that cash flows after year 6 continue at $8.25 per year perpetuity and then recalculate the investment’s NPV. Calculate the terminal value assuming that cash flows after the sixth year grow at 2% annually in perpetuity, and then recalculate the NPV.
The capital investment committee of Ellis Transport and Storage Inc. is considering two investment projects. The estimated income from operations and net cash flows from each investment are as follows: Warehouse Tracking Technology Year Income fromOperations Net CashFlow Income fromOperations Net CashFlow 1 $44,000 $145,000 $92,000 $232,000 2 44,000 145,000 70,000 196,000 3 44,000 145,000 35,000 138,000 4 44,000 145,000 15,000 94,000 5 44,000 145,000 8,000 65,000 Total $220,000 $725,000 $220,000 $725,000 Each project requires an investment of $440,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 10% for purposes of the net present value analysis. Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683…
Dogwood Company is considering a capital investment in machinery: (Click the icon to view the data.) 8. Calculate the payback. 9. Calculate the ARR. Round the percentage to two decimal places. 10. Based on your answers to the above questions, should Dogwood invest in the machinery? 8. Calculate the payback. Amount invested Expected annual net cash inflow Payback 1,500,000 24 500,000 3 years 9. Calculate the ARR. Round the percentage to two decimal places. Average annual operating income Average amount invested ARR Data Table Initial investment $ 1,500,000 Residual value 350,000 Expected annual net cash inflows 500,000 Expected useful life 4 years Required rate of return 15%
From Part A above, assume that the bank decided to give a loan of $ 59 million to Nivea Corporation (recorded for initial year). Nivea-Corporation invested the amount in a project and generated the following sequence of cash flows over six years: Year Cash Flow ($ million) 0 -59 1 4 2 5 3 6 4 7.33 5 8 6 8.25 Calculate the Net Present Value (NPV) and the Profitability Index (PI) over the six years. Assume interesr rate is 13% This project does not end after the sixth year but instead will generate cash flows far into the future. Estimate the project’s terminal value, assuming that cash flows after year 6 continue at $8.25 per year perpetuity and then recalculate the investment’s NPV. Calculate the terminal value assuming that cash flows after the sixth year grow at 2% annually in perpetuity, and then recalculate the NPV.
Instruction: Show complete solution including the cash flow diagram if not given,Formula function, Formula, Values of factors upto 4 decimal digits, Final answer is box and rounded to 2 decimal places and Recommendation is Boxed. A business owner invest $25600 in purchasing a delivery car to cater more customers and reduce delivery time. This will incur operating expenses of $0.72 per kilometer for every 400 kilometers per month the annual maintenance expense will be a uniform gradient amount of $240 which will begin at the end of the first year. Determine the Equivalent Uniform Annual Cost of the newly purchased car if interest is 12% and will be worth $11000 at the end of 5 year service life ? Express your answer as a monthly cost.
Below is a cash flow projection on a sequential-pay CMO, which has four tranches, A through D. Assume the four tranches get paid in the order of A->B->C->D. In this month tranche A has an outstanding balance of 84,000 and B has an outstanding balance of 36,000. What is the principal payment towards tranche B in this month? Enter your answer in thousands of dollars, with no decimals. For example, if your answer is $40,000, then enter 40. month 39 beginning balance $599,000 scheduled principal payment $25,000 Prepayment $18,000 Interest to MBS investors $51,000