Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 14 In the range I6:I32, calculate the running total of gross profit for each year. Home X cut Paste Filter v Select Insert Format

image text in transcribed

Question 14 In the range I6:I32, calculate the running total of gross profit for each year.

image text in transcribed

Home X cut Paste Filter v Select Insert Format Painter Clipboard Page Layout Century Gothic Font Formulas Data Review View Help Wrap Text Merge & Center v Accounting Number 20% - Acc... +08 Conditional Formatting v Format as Table v - Acc... - Acc... Styles - Acc... 40% - Acc.. 20% - Acc... Accov Inset Delete Cells Format AutoSum Clear v J Soft & Editing K Find & 8 Share Ideas 5 7 9 10 II 12 13 15 16 18 21 22 23 24 25 26 27 28 29 31 32 Startup Costs ($rr,ll) Years ot Operation Inflation Rate Projections Alignment C $12.30 32.0% $13.25 25 $30.57 $155.99 $148.06 Final Cleanup Costs ($mfl) Total Income ($mfl) Total Expenses ($mil) GIJeSS Discount Rate D Startup Year I Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Year II Year 12 Year 13 Net Present Value ($rn11J Year 14 Year 15 Year 16 Year 17 Year 18 Year 19 Year 20 Year 21 Year 22 Year 23 Year 24 Year 25 Cleanup Income ($mlJ $0.75 $1.07 $1.52 $2.16 $3.08 $4.38 $6.24 $8.88 $12.64 $18.00 $15.49 $13.32 $1 1.46 $9.86 $8.49 $7.30 $6.28 $5.40 $4.65 $4.00 $3.40 $2.80 $2.20 $1.60 $1.00 Cost of Goods ($milJ $0.24 $0.34 $0.49 $0.69 $0.99 $1.40 $2.00 $2.84 $4.05 $5.76 $4.96 $4.26 $3.67 $3.16 $2.72 $2.34 $2.01 $1.73 $1.49 $1.28 $1.09 $0.90 $0.70 $0.51 $0.32 Fixed Costs ($milJ $12.30 $1.80 $1.87 $1.95 $2.02 $2.11 $2.19 $2.28 $2.37 $2.46 $2.56 $2.66 $2.77 $2.88 $3.00 $3.12 $3.24 $3.37 $3.51 $3.65 $3.79 $3.41 $3.07 $2.76 $2.49 $2.24 $30.57 Profit ($m1J Cumulative Profit ($rnilJ (12.30) ($1.29) ($1.15) ($0.91) ($0.55) ($0.01) $0.79 $1.97 $3.67 $6.14 $9.68 $7.87 $6.29 $3.71 $2.65 $1.72 $0.90 $0.17 ($0.48) ($1.07) ($1.10) ($1.17) ($1.27) ($1.40) ($1.56) ($30.57)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Information For Decisions

Authors: Robert w Ingram, Thomas L Albright

6th Edition

9780324313413, 324672705, 324313411, 978-0324672701

Students also viewed these Accounting questions

Question

Do I want people to be more like me?

Answered: 1 week ago