-Please use excel and explain with formula in detail. KolonCo decides to launches a new product. They expect the following cash flows that are different each year. The discount rate for the time period is 8%? Assume cash flows at the end of every period. Find NPV .

Period 1: 1761

Period 2: -895

Period 3: 868

Period 4: 831

-Please use excel and explain with formula in detail.KolonCo previous annual balance sheet included: Total assets = $153,000 Item Sold = 138,000 Profit margin= 8% Sales = $180,000 New Locations Opened = 78 Total debt = $6100 Profit margin= 8% What was the ROE of the company last year?Please use excel and explain with formula in detail

-Please use excel and explain with formula in detail.you want to identify if the company is highly leveraged and therefore a higher risk for you as an investor. specifically, you want to find out how much debt the company has in comparison to each dollar of equity. determine which ratio to use, calculate it, add 6 and use the result as your answer.The latest balance sheet of KolonCo shows:

current assets: 2137

total liabilities: 2147

inventory: 322

net working capital: 1155

total assets: 5229

total equity: 1639

total debt: 2695

earnings per share: 3.13

market value: 68.57

-Please use excel and explain with formula in detail. A project requires a cash outflow of -$8239 today. In one year, $9061 will be received. In two years, $6085 will be received. In three years, another $1271 will be received, and in four years, $8947 will be received. Given a discount rate of 8%, what is the NPV?

-Please use excel and explain with formula in detail. KolonCo has some short term debt to pay off. They use liquid assets to pay it off. KolonCo has an inventory of $1775. It has net working capital of $9553 and its current liabilities are $3106. That makes the current ratio a key indicator for current investors.What is current ratio?