Q: A loan of $28,100 at 4.28% compounded semi-annually is to be repaid with payments at the end of…
A: Present value of annuity Annuity is a series of equal periodic payment at equal interval over a…
Q: t i = 12% per year compounded semiannually, determine the pre he cash flows shown below. 0 1 2 3 600…
A: Present worth is equivalent money today that is equivalent to the future value of cash flow…
Q: 2. This graph shows interest earned by an annuity that pays $17 000 at the end of each year for time…
A: Present value of annuity Annuity is a series of equal periodic payments at equal interval over a…
Q: Wanbay Corporation is interested in estimating its additional financing needed to support a growth…
A: Given: Growth rate 15% Fixed assets RM750,000 Equity RM450,000 Payables and Accruals…
Q: You want to buy a new sports coupe for $87,500, and the finance office at the dealership has quoted…
A: As per the given information: Present value (P) - $87,500 APR - 6.9% Monthly APR (I) - 6.9%/12 =…
Q: Explain the advantages and disadvantages of having protective covenants placed into the bond…
A: Covenant of protection. A provision in an indenture or loan agreement that restricts certain…
Q: 5. The circle graph represents Amy's expenses for one month. Amy spent a total of $1650 for the…
A: Given: Amount spent per month = $1,650 % spent on tuition = 27% % spent on rent = 26%
Q: a stock index fund that had an average APR of 11% over the last year. estment in 5 years and advise…
A: Information Provided: Investment = $10,000 Years = 5 Safe rate = 1.5% compounded monthly Risky rate…
Q: Wanbay Corporation is interested in estimating its additional financing needed to support a growth…
A:
Q: Bond X is a premium bond making semiannual payments. The bond pays a coupon rate of 11 percent, has…
A: Given: Bond X coupon rate =11% Bond X yield to maturity = 9% Bond Y coupon rate =9% Bond Y yield to…
Q: What is the intrinsic value of a stock which last paid a dividend of $1.75 and is expected to grow…
A: The two-stage dividend discount model: The dividend discount model recognizes that dividends are…
Q: compounded quarterly, what was the loan principal?
A: Information Provided: Years = 20 Monthly payment = $1700 Interest rate = 5.70% compounded quarterly…
Q: nventory days equal to Total Inventory Stock divided by Average Operating Expenses per day Raw…
A: Maintaining adequate inventory is very important for business and inventory is important component…
Q: AT&T is a profitable company. On its $200 Billion of debt, it pays an interest rate of 5%.…
A: Effective cost of debt is equal to after tax cost of debt.
Q: Financial Responsibilities: Describe the responsibilities of a financial analyst. Write five to…
A: Financial Analysts play an important role in an organisation. They research and use financial data…
Q: Find the annual financing cost
A: Annual Financing Cost = (interest cost +commitment fee) / usable funds * 365 / time period of…
Q: An investor has to decide how much he will be willing to pay for an investment that generates the…
A: The present value of future cash flows will be helpful in finding out the total investment which is…
Q: We assume that the stochastic process for a stock price is an Arithmetic Brownian motion, with a…
A: Probability is simply the likelihood of something occurring. When one is uncertain about the result…
Q: We project unit sales for a new household-use laser-guided cockroach search and destroy system as…
A: NPV is a capital budgeting tool to decide on whether the capital project should be accepted by the…
Q: A major retailer of appliances does some market research and finds that when the price of a type of…
A:
Q: The Buffalo News headline read “Start up by UB student sold for $250 million to major tech firm”.…
A: Present value of annuity With annuity (PMT), period (n) and interest rate (r), the present value is…
Q: Ex. 2 Calculate the combined default risk for company A and B from a combined bond issue of A and B:…
A: The company raises money by the issue of bonds but these bonds are subjected to risk of default and…
Q: On January 1, 2020, Tasya opened a savings account of IDR 1,000,000. After that date every month for…
A: Saving is the part of one's income that is not spent on current expenses. In other terms, it is…
Q: What are the four sources of capital for a firm? Explain
A: The company needs capital for the operations of the company but each have own cost of capital that…
Q: A woman borrowed P3, 000, 000 to be paid after 1.5 years with interest at 12% compounded…
A: Solution:- When an amount is invested somewhere, it earns interest on it. The amount initially…
Q: s considering putting her money ($50) into a $100 paper U.S. savings bond. Assume the guaranteed…
A: The amount being deposited grow with period due to compounding of the interest and grow to double…
Q: First Cost 300000 Present worth of the annual maintenance cost *Letters only Perpetuity of the…
A: Given:- Initial cost=P300000 Replacement required at every 15 years Annual maintenance cost= P5000…
Q: SHOW ME HOW TO DO IT IN EXCEL (SHOW THE FUNCTIONS USED AND HOW YOU USED THEM) + CLERLY SHOW INPUTS…
A: NPV is a capital budgeting techniques which help in decision making on the basis of future cash flow…
Q: 12. Two alternatives have the cash flows as shown in the Table. At a 4% interest rate, the end of…
A: The Net Present value method will be used to evaluate the two alternatives. The Net Present Value is…
Q: ou invest $3,000 in a complete portfolio. The complete portfolio is composed of a risky asset with…
A: The standard deviation of a portfolio measures the inherent risk of investing in the portfolio. It…
Q: Solar Wind is considering a new project. The project will require $325,000 for new fixed assets and…
A: NPV is a capital budgeting techniques which help in decision making on the basis of future cash…
Q: Bilboa Freightlines, S.A., of Panama, has a small truck that it uses for intracity deliveries. The…
A: The Net Present Value: The net present value is a popularly used capital budgeting technique that is…
Q: if you purchase a 13 year bond at 1300 that has a coupon rate of 6.5 what would your yield to…
A: Price of bond is 1300 Term to maturity is 13 years Coupon rate is 6.5%
Q: Sam and Deb have a weekly net income of $1700. Their monthly expenses, not related to housing, are…
A: The question of renting or buying a property is a significant problem faced every day by both…
Q: roblem 2: Value of Control: Intrinsic Valuation Acquirer Corporation would like to purchase the…
A: Dividend discount model with constant growth Dividend discount model is used to value a share. With…
Q: BHP Billiton, an Australian company, just paid $0.85 as a dividend, which is expected to grow at 5.0…
A: Here, Current Dividend is $0.85 Growth Rate is 5% Stock Price is $82 Coupon Rate is 6% Quoted Price…
Q: with payments every two weeks. For a mortgage of $225,000 at 3.85%, which option results in the…
A: Information Provided (Q21): Loan amount = $225,000 Interest rate = 3.85% Year = 15 NOTE: As per…
Q: Taussig Technologies Corporation (TTC) has been growing at a rate of 20% per year in recent years.…
A: Given: Current dividend(D0) $1.60 Required return (rs) 10% Short term growth rate (gs) 20%…
Q: An asset costs $420,000 and will be depreciated in a straight-line manner over its 3-year life. It…
A: Hai there! Thank you for the question. Post has multiple questions. As per company guidelines expert…
Q: A company issues Non-convertible bond with Equity Warrants. This security is equal to Preferred…
A: A non-convertible bond is a bond that does not give the holder the choice to convert it to shares.…
Q: The following information relates to machines A and B. Year Machine A…
A: The IRR method is used to find out the profitability of a project by calculating the return for…
Q: It is important to know how to build an amortization schedule when firms (or individuals) take out…
A: Given: Loan amount (P): $60,000 Number of periods (n): 3 years =3*12= 36 months Interest (i): 12%…
Q: Q5. You are assigned a task to compare portfolios W, X, Y and Z. During the most recent 4-year…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: RBCC ltd a local commercial bank that wants to venture into the credit card market. However, their…
A: Task: As per the requirement, the credit scoring system should be based on the usual customer…
Q: Tasty Tuna Corporation is a U.S. firm that wants to expand its business internationally. It is…
A: NPV is a capital budgeting tools to decide on whether the given capital project is beneficial for…
Q: Assume you win a lottery that will pay you $10,000 immediately, plus $20,000 one year from now,…
A: The present value of future cash flows will be calculated by discounting of the future cash flows…
Q: Mila will need $15 000 when she goes to college 5 years from now. She has 2 options for saving the…
A: Compounding is a technique to compute the future value (FV) of the present amount by using an…
Q: Q4. Samuel is planning to invest in a 12 year, 7% semiannual-pay, noncallable bond but is concerned…
A: Here, To Find: Part A. Current price of the bond =? Part B. Effective duration of the bond =?
Q: Brooks Clinic is considering investing in new heart-monitoring equipment. It has two options. Option…
A: NPV is the difference between present value of all cash inflows and initial investment NPV =PV of…
Q: Davie bought his home several years ago with a 30-year fixed rate mortgage at an interest rate of…
A: Original Loan amount will be = Purchase price - Down payment =227000 - 40000 = $187,000…
Uneven Cash Flow Stream
-
Find the present values of the following cash flow streams. The appropriate interest rate is 12%. (Hint: It is fairly easy to work this problem dealing with the individual cash flows. However, if you have a financial calculator, read the section of the manual that describes how to enter cash flows such as the ones in this problem. This will take a little time, but the investment will pay huge dividends throughout the course. Note that, when working with the calculator's cash flow register, you must enter CF0 = 0. Note also that it is quite easy to work the problem with Excel, using procedures described in the Ch04 Tool Kit.xlsx.) Do not round intermediate calculations. Round your answers to the nearest cent.
Year Cash Stream A Cash Stream B 1 $100 $250 2 400 400 3 400 400 4 400 400 5 250 100 Stream A: $
Stream B: $
-
What is the value of each cash flow stream at a 0% interest rate? Round your answers to the nearest dollar.
Stream A $
Stream B $
Step by step
Solved in 5 steps with 4 images
- Reset the Data Section of the CAPBUD2 worksheet to the original values. In requirement 4, you assessed the sensitivity of the investment’s internal rate of return to changes in some of the input data. This was done in a trial-and-error fashion. Click the Chart sheet tab. Presented on the screen is a graphical analysis of the sensitivity of the internal rate of return to changes in annual cash flows. To demonstrate the usefulness of such a chart, note the ease with which you are able to answer the following questions that might be of interest to the owner: What annual cash flow (approximately) is required to: earn 0% rate of return? _______________ earn 10% rate of return? _______________ earn over 20% rate of return? _______________ Approximately, how much is the rate of return reduced for each drop of $10,000 annual cash flow? When the assignment is complete, close the file without saving it again. Worksheet. The CAPBUD2 worksheet handles only cash inflows that are even in amount each year. Many capital projects generate uneven cash inflows. Suppose that the new store had expected cash earnings of $80,000 per year for the first two years, $140,000 for the next four years, and $220,000 for the last four years. The new store will generate the same total cash return ($1,600,000) as in the original problem, but the timing of the cash flows is different. Alter the CAPBUD2 worksheet so that the NPV and IRR calculations can be made whether there are even or uneven cash flows. When done, preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as CAPBUDT. Hint: One suggestion is to label column F in the scratch pad as Uneven cash flows. Enter the uneven cash flows for each year. Modify FORMULA3 to include these cash flows. Modify the formulas in the range E30 to E39 to include the new data. Then set cell E10 (estimated Annual Net Cash Inflow) to zero. When you have even cash flows, use cell E10 and set column F in the scratch pad to zeros. If you have uneven cash flows, set cell E10 to zero and fill in column F in the scratch pad. Note that this solution causes garbage to come out in cells E15 and E16 because those formulas were not altered. Check figure for uneven cash flows: NPV (cell E17), $68,674. Chart. Using the CAPBUD2 file, develop a chart just like the one used in requirement 6 to show the sensitivity of net present value to changes in cost of the investment amount from $440,000 to $500,000 (use $10,000 increments). Complete the Chart Tickler Data Table and use it as a basis for preparing the chart. Enter your name somewhere on the chart. Save the file again as CAPBUD2. Print the chart.Find the present values of the following cash flow streams. The appropriate interest rate is 6%. Round your answers to the nearest cent. (Hint: It is fairly easy to work this problem dealing with the individual cash flows. However, if you have a financial calculator, read the section of the manual that describes how to enter cash flows such as the ones in this problem. This will take a little time, but the investment will pay huge dividends throughout the course. Note that, when working with the calculator's cash flow register, you must enter CF0 = 0. Note also that it is quite easy to work the problem with Excel, using procedures described in the Chapter 4 Tool Kit.) Year Cash Stream A Cash Stream B 1 $100 $300 2 400 400 3 400 400 4 400 400 5 300 100 Stream A $ $1,327.20 Stream B $ $1,366.43 What is the value of each cash flow stream at a 0% interest rate? Round your answers to the nearest cent.…Find the present values of the following cash flow streams. The appropriate interest rate is 12%. (Hint: It is fairly easy to work this problem dealing with the individual cash flows. However, if you have a financial calculator, read the section of the manual that describes how to enter cash flows such as the ones in this problem. This will take a little time, but the investment will pay huge dividends throughout the course. Note that, when working with the calculator's cash flow register, you must enter CF0 = 0. Note also that it is quite easy to work the problem with Excel, using procedures described in the Ch04 Tool Kit.xlsx.) Do not round intermediate calculations. Round your answers to the nearest cent. Year Cash Stream A Cash Stream B 1 $100 $300 2 400 400 3 400 400 4 400 400 5 300 100 Stream A: $ Stream B: $ What is the value of each cash flow stream at a 0% interest rate? Round your answers to the nearest dollar. Stream A $ Stream B $
- Find the present values of the following cash flow streams. The appropriate interest rate is 8%. (Hint: It is fairly easy to work this problem dealing with the individual cash flows. However, if you have a financial calculator, read the section of the manual that describes how to enter cash flows such as the ones in this problem. This will take a little time, but the investment will pay huge dividends throughout the course. Note that, when working with the calculator's cash flow register, you must enter CF0 = 0. Note also that it is quite easy to work the problem with Excel, using procedures described in the Ch04 Tool Kit.xlsx.) Do not round intermediate calculations. Round your answers to the nearest cent. Year Cash Stream A Cash Stream B 1 $100 $250 2 400 400 3 400 400 4 400 400 5 250 100 Stream A: $ Stream B: $ What is the value of each cash flow stream at a 0% interest rate? Round your answers to the nearest dollar.Find the value of the unknown quantity in the cash flow diagram to establish equivalence of cash inflows and outflows. Let i = 12% per year. Use a uniform gradient factor in your solution.Use the ERR method to analyze the cash-flow pattern shown in the accompanying shown table. The IRR is indeterminant (none exists), so the IRR is not a workable procedure. The external reinvestment rate (∈) is 12% per year, and the MARR equals 15%.
- Solve the following and draw the cash flow diagram From the given cash flow diagram, find the future value of the geometric gradient with unknown constant rate f at i = 0.111 compounded annually -rate of increase should be rounded of by 5 decimal places and final answer to 2 decimal places -the value in the graph is 5000 and 9900 Note: Do not use excel(Present value of complex cash flows) You have an opportunity to make an investment that will pay $100 at the end of the first year, $100 at the end of the second year, $300 at the end of the third year, $400 at the end of the fourth year, and $200 at the end of the fifth year. a. Find the present value if the interest rate is 11 percent. (Hint: You can simply bring each cash flow back to the present and then add them up. Another way to work this problem is to either use the =NPV function in Excel or to use your CF key on a financial calculator—but you'll want to check your calculator's manual before you use this key. Keep in mind that with the =NPV function in Excel, there is no initial outlay. That is, all this function does is bring all the future cash flows back to the present. With a financial calculator, you should keep in mind that CF0 is the initial outlay or cash flow at time 0, and, because there is no cash flow at time 0, CF0=0.) b. What would…Consider the following cash flows: Year Cash Flow 0 –$ 32,000 1 14,200 2 17,500 3 11,600 a. What is the NPV at a discount rate of zero percent? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) b. What is the NPV at a discount rate of 10 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. What is the NPV at a discount rate of 20 percent? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) d. What is the NPV at a discount rate of 30 percent? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
- Present and Future Values of Single Cash Flows for Different Interest Rates Use both the TVM equations and a financial calculator to find the following values. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in parts b and d, and in many other situations, to see how changes in input variables affect the output variable.) Do not round intermediate calculations. Round your answers to the nearest cent. An initial $700 compounded for 10 years at 6%. $ An initial $700 compounded for 10 years at 12%. $ The present value of $700 due in 10 years at a 6% discount rate. $ The present value of $700 due in 10 years at a 12% discount rate. $Consider the following cash flows: Year Cash Flow 0 −$28,300 1 15,400 2 13,500 3 9,900 a. What is the profitability index for the cash flows if the relevant discount rate is 9 percent? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.) b. What is the profitability index if the discount rate is 14 percent? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.) c. What is the profitability index if the discount rate is 25 percent? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.)This problem is useful for testing the ability of financial calculators or excel. Consider the following cash flows. How many different IRRs are there (Hint: search between 20 percent and 70 percent)? When should we take this project?( u can use Excel) Year Cash Flow 0 -$3,024 1 17,172 2 -36,420 3 34,200 4 -12,000