Homework Answers
![Answer to Q#1 (First question in the list-Seahawk Problem Part-(a Part-(b Annual Interest rate, RATE Number of yearly payments, NPER Initial deposit in the account, PV Target maturity amount, FV Annual deposit type, TYPE Annual deposits required 15 $0 1,500,000 $1,500,000 15 $0 1 0 if deposits made at the end of each period; 1 if deposits made at the beginning of each period 55,244.32 $51,152.15 [Ref: NOTE] NOTE: Annual deposits required is calculated using EXCEL FUNCTION PMT(rate,nper,pv,fv,type) where rate-8%; nper=15, pv:0; fv=-1500000; type:0 or 1; Here, value for fv is negative because it denotes cash inflow; type-0 for Part-(a), as it is ordinary annuity; type-1 for Part-(b) as it is annuity due Part-(a) Part-(b 2 Annual Interest rate, RATE 3 Number of yearly payments, NPER 4 Initial deposit in the account, PV 5 Target maturity amount, FV 6 Annual deposit type, TYPE 7 Annual deposits required 15 $0 1,500,000 15 $0 1,500,000 10 if deposits made at the end of each period; 1 if deposits made at the beginning of each period PMTB2,вз,B4,-BSB6) -PMT(C2.c3.c4,5.co [Ref -](http://img.homeworklib.com/questions/91000730-78ae-11ea-8ab5-cbad6fbb9fe9.png?x-oss-process=image/resize,w_560)
![Requirement-(C Monthly interest rate, RATE Number of annuity payment, NPER Monthly annuity payments, PMT Initial deposit in the account, PV Interest compounding type, TYPE Investment value in 15 years 0.75% 180 [15 years x 12] $1,000 $0 1-0 if annuity regular (at the endlofeach year; 1 if annuity due (at the beginningl of each year $381,243.81 [Ref: NOTE] NOTE Investment value in 15 years is calculated using EXCEL FUNCTION FV(rate,nper,pmt,pv,type) where rate:0.75%; nper=180; pmt-1000, pv=0; type-1; Here, value for pv is negative as it denotes cash inflow; type 1 because it is annuity due 1 Monthly interest rate, RATE 2 Number of annuity payment, NPER 3 Monthly annuity payments, PMT 4 Initial deposit in the account, PV 5 Interest compounding type, TYPE 6 Investment value in 15 years 0.75% -15 12 [15 years x 12] $1,000 S0 1 0 if annuity regular (at the end) of each year; 1 if annuity due (at the beginningl of each year FV(B1,B2,-B3,B4,B5) [Ref: NOTE]](http://img.homeworklib.com/questions/9184f020-78ae-11ea-9283-13501828dcb2.png?x-oss-process=image/resize,w_560)
Add Answer to:
Seahawk Enterprises has an estimated pension liability of $1.5 million due in 15 years. The company...
A company has a pension liability of $460,000,000 that it must pay in 29 in years....
A company has a pension liability of $460,000,000 that it must pay in 29 in years. If it can earn an annual interest rate of 4.2 percent, how much must it deposit today to fund this liability? Multiple Choice O $133,883,255.09 Ο $139,506.351.81 Ο Ο 44,08571.14 Ο $11755.30770 ( $121423,867.90
please show on a ba texas instrument calculator 8. Uneven cash flows A series, or stream,...
please show on a ba texas instrument calculator
8. Uneven cash flows A series, or stream, of cash flows may not always necessarily be an annuity. Cash flows can also be uneven and nonconstant, but the concept of the time value of money applies to uneven cash flows as well Consider the following case: Swanky Beverage Co. expects the following cash flows from its manufacturing plant in Palau over the next 5 years: Year Annual Cash Flows $4,100,000 $5,000,000 $3,000,000...
CENGAGE | MINDTAP Q se Assignment 04 - Time Value of Money The Purple Lion Beverage...
CENGAGE | MINDTAP Q se Assignment 04 - Time Value of Money The Purple Lion Beverage Company expects the following cash flows from its manufacturing plant in Palau over the next five years: Year 1 $100,000 Annual Cash Flows Year 2 Year 3 $37,500 $480,000 Year 4 $300,000 Year 5 $550,000 The CFO of the company believes that an appropriate annual interest rate on this investment is 6.5%. What is the present value of this uneven cash flow stream, rounded...
The Purple Lion Beverage Company expects the following cash flows from its manufacturing plant in Palau...
The Purple Lion Beverage Company expects the following cash flows from its manufacturing plant in Palau over the next five years Annual Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 $250,000 $37,500 $180,000 $450,000 $350,000 The CFO of the company believes that an appropriate annual interest rate on this investment is 6.5%. What is the present value of this uneven cash flow stream, rounded to the nearest whole dollar? $1,425,000 $467,500 $1,642,500 $1,022,070 Identify whether the situations described in the following table are...
10. Uneven cash flows A Aa E A series of cash flows may concept of the...
10. Uneven cash flows A Aa E A series of cash flows may concept of the time valu s necessarily be an annuity. Cash flows can also be uneven and variable in amount, but the Il continue to apply Consider the following case: The Purple Lion Beverage Company expects the following cash flows from its manufacturing plant in Palau over the next six years: Year 1 Year 2 Annual Cash Flows Year 4 $180,000 $450,000 Year 3 Year 6 $375,000...
(Present value of annuity payments) The state lottery's million-dollar payout provides for $1.5 million to be...
(Present value of annuity payments) The state lottery's million-dollar payout provides for $1.5 million to be paid in 20 installments of $75000 per payment. The first $75000 payment is made immediately, and the 19 remaining $75000 payments occur at the end of each of the next 19 years. If 8 percent is the discount rate, what is the present value of this stream of cash flows? If 16 percent is the discount rate, what is the present value of the...
(Present value of annuity payments) The state lottery's million-dollar payout provides for $1.5 million to be pa...
(Present value of annuity payments) The state lottery's million-dollar payout provides for $1.5 million to be paid in 20 installments of $75000 per payment. The first $75000 payment is made immediately, and the 19 remaining $75000 payments occur at the end of each of the next 19 years. If 8 percent is the discount rate, what is the present value of this stream of cash flows? If 16 percent is the discount rate, what is the present value of the...
Please help this is for a grade!! A series of cash flows may not always necessarily...
Please help this is for a grade!!
A series of cash flows may not always necessarily be an annuity. Cash flows can also be uneven and variable in amount, but the concept of the time value of money will continue to apply. Consider the following case: The Purple Lion Beverage Company expects the following cash flows from its manufacturing plant in Palau over the next four years: Annual Cash Flows Year 3 Year 1 Year 2 Year 4 $37,500 $180,000...
A series of cash flows may not always necessarily be an annuity. Cash flows can also...
A series of cash flows may not always necessarily be an annuity. Cash flows can also be uneven and variable in amount, but the concept of the time value of money will continue to apply. Consider the following case: The Purple Lion Beverage Company expects the following cash flows from its manufacturing plant in Palau over the next five years! Annual Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 $100,000 $20,000 $480,000 $450,000 $550,000 The CFO...
River Enterprises has $490 million in debt and 21 million shares of equity outstanding. Its exce...
River Enterprises has $490 million in debt and 21 million shares of equity outstanding. Its exce ss cash reserves are $ 14 million. They are expected to generate $208 million in free cash flows next year with a growth rate of 2% per year in perpetuity. River Enterprises' cost of equity capital is 12%. After analyzing the company, you believe that the growth rate should be 3% instead of 2%. How much higher (in dollars) would the price per share...
A company has a pension liability of $460,000,000 that it must pay in 29 in years. If it can earn an annual interest rate of 4.2 percent, how much must it deposit today to fund this liability? Multiple Choice O $133,883,255.09 Ο $139,506.351.81 Ο Ο 44,08571.14 Ο $11755.30770 ( $121423,867.90
please show on a ba texas instrument calculator
8. Uneven cash flows A series, or stream, of cash flows may not always necessarily be an annuity. Cash flows can also be uneven and nonconstant, but the concept of the time value of money applies to uneven cash flows as well Consider the following case: Swanky Beverage Co. expects the following cash flows from its manufacturing plant in Palau over the next 5 years: Year Annual Cash Flows $4,100,000 $5,000,000 $3,000,000...
CENGAGE | MINDTAP Q se Assignment 04 - Time Value of Money The Purple Lion Beverage Company expects the following cash flows from its manufacturing plant in Palau over the next five years: Year 1 $100,000 Annual Cash Flows Year 2 Year 3 $37,500 $480,000 Year 4 $300,000 Year 5 $550,000 The CFO of the company believes that an appropriate annual interest rate on this investment is 6.5%. What is the present value of this uneven cash flow stream, rounded...
The Purple Lion Beverage Company expects the following cash flows from its manufacturing plant in Palau over the next five years Annual Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 $250,000 $37,500 $180,000 $450,000 $350,000 The CFO of the company believes that an appropriate annual interest rate on this investment is 6.5%. What is the present value of this uneven cash flow stream, rounded to the nearest whole dollar? $1,425,000 $467,500 $1,642,500 $1,022,070 Identify whether the situations described in the following table are...
10. Uneven cash flows A Aa E A series of cash flows may concept of the time valu s necessarily be an annuity. Cash flows can also be uneven and variable in amount, but the Il continue to apply Consider the following case: The Purple Lion Beverage Company expects the following cash flows from its manufacturing plant in Palau over the next six years: Year 1 Year 2 Annual Cash Flows Year 4 $180,000 $450,000 Year 3 Year 6 $375,000...
Please help this is for a grade!!
A series of cash flows may not always necessarily be an annuity. Cash flows can also be uneven and variable in amount, but the concept of the time value of money will continue to apply. Consider the following case: The Purple Lion Beverage Company expects the following cash flows from its manufacturing plant in Palau over the next four years: Annual Cash Flows Year 3 Year 1 Year 2 Year 4 $37,500 $180,000...
A series of cash flows may not always necessarily be an annuity. Cash flows can also be uneven and variable in amount, but the concept of the time value of money will continue to apply. Consider the following case: The Purple Lion Beverage Company expects the following cash flows from its manufacturing plant in Palau over the next five years! Annual Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 $100,000 $20,000 $480,000 $450,000 $550,000 The CFO...
Most questions answered within 3 hours.
-
Hydrobromic acid
dissolves solid iron according to the followiaung reaction:
Fe(s)+2HBr(aq)→
FeBr2(aq)+ H2(g)
Part A. What...
asked 1 hour ago -
Verify the following vector identity in SPHERICAL
COORDINATES.
div(curl(A)) = 0
asked 2 hours ago -
The work function (Φ) for a metal is 7.50×10-19 J.
What is the longest wavelength (nm)...
asked 3 hours ago -
1. Would the following procedural changes cause the
calculated mass percent Ni2+ ion in Ni(NH3)nCl2 to...
asked 5 hours ago -
1. Why does the voltage of the capacitor vary with frequency?
where does this missing voltage...
asked 6 hours ago -
p p please write each step out clearly
3. A manager of a company is considering...
asked 5 hours ago -
On October 1, Ebony Ernst organized Ernst Consulting; on October
3, the owner contributed $83,540 in...
asked 6 hours ago -
A.)As an electron moves through a region of space, its speed
decreases from 9.60 × 106...
asked 6 hours ago -
In java with the netbeans program do:
Through object programming
Create a class "ContadorP", which is...
asked 6 hours ago -
Pattern Corporation acquired all of Science
Company's outstanding stock on January 1, 2016 for $600,000 cash....
asked 6 hours ago -
Here are all accounts Tyler Co. maintains.
Tax expenses $4,750
Common stocks $48,840
SG&A expenses $2,500...
asked 7 hours ago -
Lis
out the types and equation of wind profile and the respective
variables in the fds...
asked 7 hours ago