Reference no: EM13976180
Asses Present Value and Future Value Problems
Develop an assessment of each of the following problems:
1. Calculate the monthly mortgage payment of principal and interest for the a loan with an initial balance of 150,000, an annual stated interest rate of 6%, and 30 years to maturity. Use Excel to develop this response and present your result within a separate page of the spreadsheet.
2. Develop the amortization table for the loan outlined in problem 1. Use an Excel spreadsheet to develop and present this table. Present this result in a separate page of the spreadsheet.
3. Further, given the structure of problem 1, develop a summary table showing how the monthly payment would adjust for all options with an interest rate at 5%, 6% and 7% as well as a maturity at 15 years, 20 years and 30 years. Use Excel to develop and present this summary table. Present the results in a separate page of the spreadsheet.
|
Target market customers for products and services
: What are the characteristics (e.g., age, income, education) of the target market customers for the following products or services? (a) National Geographic magazine, (b) Chobani Greek Yogurt, (c) New York Giants football team, and (d) Facebook.
|
|
About the firms operations and its cash flows
: A firm has days' sales in inventory of 105 days, an average collection period of 35 days, and takes 42 days, on average, to pay its accounts payable. Taken together, what do these three figures imply about the firm's operations and its cash flows?
|
|
Why common stock investor demands higher dividend rate
: There are two primary means to earn income as a stockholder. The first method is dividend income and the second method is earnings from capital gains. Discuss the dividend payment requirements of a common stock versus preferred stock, in terms of whi..
|
|
Common stock pays a dividend
: Abercrombie & Fitch's common stock pays a dividend of $0.70. It is currently selling for $34.14. If the firm's investors require a return of 10 percent on their investment from buying Abercrombie & Fitch stock, what growth would Abercrombie & Fitch h..
|
|
Asses present value and future value problems
: Calculate the monthly mortgage payment of principal and interest for the a loan with an initial balance of 150,000, an annual stated interest rate of 6%, and 30 years to maturity. Use Excel to develop this response and present your result within a se..
|
|
What is the equipments after-tax net salvage value
: Allen Air Lines must liquidate some equipment that is being replaced. The equipment originally cost $15 million, of which 80% has been depreciated. The used equipment can be sold today for $3.75 million, and its tax rate is 30%. What is the equipment..
|
|
About the value of perpetual payments
: A friend who owns a perpetuity that promises to pay $1,000 at the end of each year, forever, comes to you and offers to sell you all of the payments to be received after the 25th year for a price of $1,000. At an interest rate of 10%, should you pay ..
|
|
What is the standard deviation of the return on investment
: Barbara is considering investing in a stock and is aware that the return on that investment is particularly sensitive to how the economy is performing. Her analysis suggests that four states of the economy can affect the return on the investment. Wha..
|
|
Management will invest cash flows
: Trigen Corp. management will invest cash flows of $1,340,423, $787,958, $958,711, $818,400, $1,239,644, and $1,617,848 in research and development over the next six years. If the appropriate interest rate is 7.15 percent, what is the future value of ..
|