Question: PLEASE ONLY ANSWER WITH EXCEL FORMULAS AND IN EXCEL FORMAT, I NEED STEP BY STEP INSTRUCTIONS AND A SCREEN SHOT OF EXCEL WITH AND WITHOUT

PLEASE ONLY ANSWER WITH EXCEL FORMULAS AND IN EXCEL FORMAT, I NEED STEP BY STEP INSTRUCTIONS AND A SCREEN SHOT OF EXCEL WITH AND WITHOUT THE FORMULAS, PLEASE EXCEL ONLY. Find the value of P for which the inflows will equal the outflows. Find the effective rate first.

Rate

12 %

p y c d

Year Outflows Inflows

0 -

1 - 12

2 - 16

3 - 24

4 0

5 -

P $

24, 000

6 -

P $

30, 000

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 Finance Questions!

please help solving using excel formulas excel B D E F G H 8 Steps to Perform: 9 Points 10 Step Instructions Possible 11 Start Excel. Download and open the workbook named: 0 12 1...

prepare an income statement, retained earnings statement, and balance sheet for Pepper Shoes, Inc. Also, if you can show me how to set up the trial balance (#9 on page 9) thank you. Page 7 Question...

need help woth this ASAP! please ACCT 201 Case Spring 2019 4. Financial Stetements Based on the adjusted trial balance on the next poge, prepare the Multi-Step Income Statement, the Retained Earnings...

please answer a,b,c,d and e please fill in the excel document as listed below and provide each step to solve and answer each question. there is two excel pages, part (b) and part (d) please show both...

Question 5 The most recent year's income statement for Modernized Pharma Company was as follows (in millions of dollars): Sales $ 5.750 Cash-based Cost of Goods Sold $ 4,200 Depreciation $ 810...

Question 1 Suppose that an analyst has noticed that the return on equity of the Johnson and Smith Company has declined from 2019 to 2020. Using the DuPont formula, explain the source of this decline....

Question 4 The Amazing Streaming Co. has just paid an annual dividend of 40 cents. You forecast that for the next five years dividends will grow at the rate of 25% a year over the period. From year...

Question 2 a. How long will it take to increase your money tenfold with the interest rate of 15 percent? b. On the advice of your broker 15 years ago, you invested in a $6 stock that is now selling...

Follow the instruction Question 6 What effective annual rate results from daily compounding of 8% (Assume 365 days)? b. Suppose that you carry a sizable balance on your credit card, issued by your...

Question 3 You have the following information on three bonds: Bond 1, Bond 2, and Bond 3. Bond Price Coupon YTM Time to maturity Bond 1 10022 12% 17 years Bond 2 22.5% 1.5% 15 years Bond 3 998 3%...

Calculate the value for the equilibrium constant for each of the following aqueous reactions. a. NH3 + H3O+ NH4+ + H2O b. NO2- + H3O+ HNO2 + H2O c. NH4+ + CH3CO2- NH3 + CH3CO2H d. H3O+ + OH- 2H2O...

Conch Republic Electronics is a mid sized electronics manufacturer located in Key West, Florida. The company president is Shelley Couts, who inherited the company. When it was founded over 70 years...

How to compute the change in cash?

Which of the _ following is _ true _ with regard to products? A ) The quality of products is far more difficult to measure than that of services. B ) Products do not include experiences,...

=+g. Does it deliver one, instantly understandable message?

=+e. Does it entertain, inform and/or engage the reader?

=+h. Do all of the related materials project one cohesive message?