Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. i'm stuck on the unfilled shaded yellow parts. it

I'm stuck on the unfilled shaded yellow parts. It needs to be in excel formula....

70.2K

Verified Solution

Question

Accounting

I'm stuck on the unfilled shaded yellow parts. It needs to be in excel formula.

image

1 Laurman, Inc. is considering the following project: 2 Required investment in equipment 2,205,000 3 Project life 4 Salvage value 225,000 6 The project would provide net operating income each year as follows: 7 Sales 8 Variable expenses 9 Contribution margin 10 Fixed expenses: 11Salaries, rent and other fixed out-of pocket costs 12Depreciation 13 Total fixed expenses 14 Net operating income 15 16 Company discount rate 17 18 1.Compute the annual net cash inflow from the project. 19 20 2. Complete the table to compute the net present value of the investment. 21 2,750,000 1,600,000 1,150,000 520,000 350,000 870,000 280 18% 630,000 Year(s) Now 23 24 Initial investment 25 Annual cost savings 26 Salvage value of the new machine 27 Total cash flow:s 28 Discount factor 29 Present value of the cash flows 30 Net present value $ (2,205,000.00) 630,000.00 $225,000.00 1.000

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

7 Sketch the domain of the function f x y z x y z ln...

Statistics
Q

A.) explain the business culture of new Zealand , b.) characteristics of business culture of new...

Operations Management
Q

what is the value of ???? ?(t+2)e^(?2t)u(t)dt?

Advance Math
Q

Individuals with sickle cell anemia are homozygous for the gene Hbs, which specifies an altered...

Biology
Q

graph of the hyperbolic paraboloid 2 x 9z Choose the correct graph of the hyperbolic...

Geometry
Q

In a survey, 30 people were asked how much they spent on their child's last...

Basic Math
Q

3 2 ID 3850057 MTH ALG1 6 b 1 y Points Reyd 0 of 1...

Algebra
Q

Calculate acute angles only without a calculator 5 1 1 If sin Asin B the...

Algebra
Q

On January 1 , a company issues a $1,000,000,10%,5 year bond that buys semiannual interest...

Accounting
Q

Units completed and transferred out: 150,000 Units in Ending Work in Process Inventory:...

Accounting
Q

4. Find LCM(168, 280) using your prime factorization. Show what you multiplied to get the...

Accounting
Q

Direct Materials Mix and Yield Variances Chypre, Inc., produces a cologne mist using a solvent...

Accounting