Question: -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

-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?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

On December 31, Pacifica, Inc., acqulred 100 percent of the voting stock of Seguros Company. Pacifica will malntain Seguros as a wholly owned subsldlary with its own legal and accounting identity....

Perpetuities An investor purchasing a British consol is entitled to receive annual payments from the British government forever. What is the price of a consol that pays $125 annually if the next...

Please Answer all of the questions Given the above data, calculate the future value In each case. (Using the formula and also a financial calculator) Given the above data, calculate the present value...

JUUSULW.ICUSCI Abstract Brooks Hamilton recently completed his third year in college and has just started a summer internship at a prestigious Wall Street investment firm. The investment firm is very...

During the depression of the 1930s, Ben Jenkins, Sr., a wealthy, expansion-oriented lumberman whose family had been in the lumber business in the southeaster United States for several generations,...

This is for help on final project II. Most of the work is already done through the first project, Project I. I have attached Project I as well as each Milestone project that lead to the final...

Need help with a finance question urgently... See the attachment and send the solution in attachment with clear details. Chapter 5 - Term Structure of Interest Rates Interest rates vary by maturity...

Need help with a finance project. Thanks in advance. Chapter 5 - Term Structure of Interest Rates Interest rates vary by maturity of the instrument and by risk characteristics 3 mo T-bill 3 mo...

I have attached the questions and answers for several problems I just need to know the steps used to reach the answers. Step by step showing formulas used and why would be optimal thank you. Session...

As a group: Review Figure 3 that shows the cash flows estimated before and after Katrina. Calculate the NPV of cash flows for each stream of cash before and after Katrina using a discount rate of 9%....

Please help with question #3! I do not know how to calculate Northern Virginia Community College Assignment for Course: Submitted to: Submitted by: Date of Submission Finance 215 - Financial...

A steel truss is shown in Figure Q1b. Assuming that the same steel section is used for all members: Calculate the area of the the smallest steel section such that the maximum vertical deflection at...

A container filled with 45 kg of liquid water at 95°C is placed in a 90-m3 room that is initially at 12°C. Thermal equilibrium is established after a while as a result of heat transfer...

Assuming the stock price is certain to be greater than the exercise price on a call option, what is the value of the call? Why?

The following table provides a probability distribution for the random variable x. x f(x) 3 ...........25 6 ...........50 9 ...........25 a. Compute e(x), the expected value of x. b. Compute 2, the...

The percent frequency distributions of job satisfaction scores for a sample of information systems (IS) senior executives and middle managers are as follows. The scores range from a low of 1 (very...

Abbott Equipment leased a protein analyzer to Werner Chemical, Inc. on September 30, 2018. Abbott purchased the machine from NutraLabs, Inc. at a cost of $6 million. The five-year lease agreement...

Larry Krovitz is a salesman who works at a used-car showroom in Sydney, Australia. Its the last week of July but he is yet to meet his sales target for the month. A customer, Harold Kumar, who wants...

Every candle maker in Town A must have a license. The cost of a license is the same regardless of the number of candles a business produces. a. Assuming that the candle market is perfectly...

please dont use chat gpt AI 1 4 0 . Welchen Einfluss hat die Dividendenpolitik auf die Attraktivit t einer Aktie in einem Niedrigzinsumfeld?

3. Several years ago, 8,000 Amtrak workers agreed not to disrupt service by walking out, at least not until a court hearing was held. Amtrak had asked the courts for a temporary restraining order,...

6. What actions might make employers lose elections?

3. This case and this chapter both had something to say about how organizational culture influences ethical behavior. What role do you think culture played at Enron? Give five specific examples of...