How will inflation and rising interest rates over the next year affect those invested in 10-year U.S. Treasuries versus those invested in 30-year U.S. Treasuries, which investors would suffer larger losses,explain?

John, 38, makes $125,000 per year. He has a 35 year old wife, Nancy, and a daughter who just turned 7. John’s share of the family’s consumption is 21%, and he pays an average tax rate of 28%. He plans to work another 30 years and expects salary increases equal to inflation, which he expects to be 3% annually. He expects to earn an 8% nominal rate of return on his investments.

1. Use the Human Life Value (HLV) method to calculate John’s appropriate amount of life insurance coverage.

Please show up calculate in Excel, Thank you!

McKay Company sells merchandise with a one-year warranty. In Year 1, sales consisted of 1,200 units. It is estimated that warranty repairs will average $10 per unit sold, and 30% of the repairs will be made in Year 1 and 70% in Year 2. In the Year 1 income statement, McKay should show warranty expense of

A one-year T-bond rate is currently 3% and the one-year rate in 12 months is expected to be 2.5% in addition to a liquidity premium of 0.25%. Based on this information, what do expect the two-year T-bond rate to currently be?

1. You buy Kathy Place in Year 0 for $500.   You sell it in year 7 for $1,000.  While owning the property, you made $50 a year.  What is your annual return from property appreciation?
   1. 7.34%
   2. 10.41%
   3. 17.52%
   4. 18.35%

1. A four-year financial project has estimates of net cash flows shown in the following table:

It will cost $65,000 to implement the project, all of which must be invested at the beginning of the project. After the fourth year, the project will have no residual value.

Using the most likely estimates of cash flows, conduct a discounted cash flow calculation assuming a 20 percent hurdle rate with no inflation.

What is the discounted profitability index of the project?

John, 38, makes $125,000 per year. He has a 35 year old wife, Nancy, and a daughter who just turned 7. John’s share of the family’s consumption is 21%, and he pays an average tax rate of 28%. He plans to work another 30 years and expects salary increases equal to inflation, which he expects to be 3% annually. He expects to earn an 8% nominal rate of return on his investments.

Use the Capitalization of Earning method to determine John’s appropriate life insurance coverage (note: use FSE and the real interest rate. Please show p calculate in Excel, Thank you

R.V. Motors had $80,000 in cash at year-end 2012 and $30,000 in cash at year-end 2013. Cash flow from long-term investing activities totaled $–200,000, and cash flow from financing activities totaled $240,000. What was the cash flow from operating activities?

Hampton Industries had $68,000 in cash at year-end 2017 and $15,000 in cash at year-end 2018. The firm invested in property, plant, and equipment totaling $220,000. Cash flow from financing activities totaled +$240,000. Round your answers to the nearest dollar, if necessary.

What was the cash flow from operating activities? Cash outflow, if any, should be indicated by a minus sign. $

If accruals increased by $35,000, receivables and inventories increased by $185,000, and depreciation and amortization totaled $5,000, what was the firm's net income? $