Use Goal Seek to calculate the changing value in cell B12 that will result in a set value in cell B19 of $0

Michigan mattress company is considering the purchase of land and the construction of a new plant. the land, which would be bought immediately (at t = 0), has a cost of $100,000 and the building, which would be erected at the end of the first year (t = 1), would cost $500,000. it is estimated that the firm's afterminustax cash flow will increase by $100,000 starting at the end of the second year, and that this incremental flow would increase at a 10 percent rate annually over the next 10 years. what is the approximate payback period?

The next dividend payment by savitz, inc., will be $2.08 per share. the dividends are anticipated to maintain a growth rate of 6 percent forever. if the stock currently sells for $42 per share, what is the required return?

Can you post a video on of the question that you need on