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
- Find the present values of the following cash flow streams. The appropriate interest rate is 6%. (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 $200 2 400 400 3 400 400 4 400 400 5 200 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.a. Find the present values of the following cash flow streams. The appropriate interest rate is 9%. (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 CFo = 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 $200 2. 400 400 400 400 4 400 400 200 100 Stream A: $ Stream B: $ 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 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.…Present and Future Values of Single Cash Flows for Different Periods Find the following values, using the equations, and then work the problems using a financial calculator to check your answers. Disregard rounding differences. (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 $600 compounded for 1 year at 6%. $ An initial $600 compounded for 2 years at 6%. $ The present value of $600 due in 1 year at a discount rate of 6%. $ The present value of $600…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 $800 compounded for 10 years at 5%. $ An initial $800 compounded for 10 years at 10%. $ The present value of $800 due in 10 years at a 5% discount rate. $ The present value of $800 due in 10 years at a 10% discount rate. $
- Consider an investment where the cash flows are: – $946.21 at time t = 0 (negative since this is your initial investment) $377 at time t = 1 in years $204 at time t = 2 in years $499 at time t = 3 in years (a) Use Excel's "Solver" to find the internal rate of return (IRR) of this investment. Take a screen shot showing Solver open with your entries for the function clearly visible. Paste the screen shot into an application (like Paint), and save it as a (.png) file. Upload your screenshot below. (b) What is the value of IRR found by Solver?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.Select all the correct statements. The internal rate of return (IRR) generated by a positive cash flow stream of n payments a. is always given by the solution of a quadratic equation b. is always bigger or equal than -1 c. can be -2 for a suitable cashflow d. can be 17 for a suitable cashflow e. is always smaller or equal than +1
- (Present value of an uneven stream of payments) You are given three investment alternatives to analyze. The cash flows from these three investments are shown in the popup window: Assuming a discount rate of 16 percent, find the present value of each investment. a. What is the present value of investment A at 16 percent annual, discount rate? S (Round to the nearest cènt.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) INVESTMENT B END OF YEAR 1 23456TBLG 7 8 9 10 A $18,000 18,000 18,000 18,000 18,000 $18,000 18,000 18,000 18,000 18,000 18,000 C $18,000 90,000 18,000 -Which of the following statements are correct? The internal rate of return (IRR) generated by a positive cash flow stream of n payments. (a)is always smaller or equal than +1 (b)is always given by the solution of a quadratic equation (c)is always bigger or equal than -1 (d)can be 17 for a suitable cashflow (e)can be -2 for a suitable cashflowARCI Instruments manufactures a ventilation controller designed for monitoring and controlling carbon monoxide in parking garages, boiler rooms, tunnels, etc. The net cash flow associated with one phase of the operation is shown on the next page. (a) How many possible rate of returnvalues are there for this cash flow series? (b) Find all the rate of return values between 0 and 100% using tabulated factors and a spreadsheet.