Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the excel formula for year 1 ending balance (D34) to equal $111,495.637 based on the sheet information? begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} hline & A & B

What is the excel formula for year 1 ending balance (D34) to equal $111,495.637 based on the sheet information?image text in transcribed

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H & 1 \\ \hline 2 & Life & \multicolumn{2}{|c|}{10 years } & & & & & & \\ \hline 3 & & M1 & M2 & & & & & & \\ \hline 4 & Investment: & & & & & & & & \\ \hline 5 & Machine tool purchase & 121,000 & 125,000 & & & & & & \\ \hline 6 & Automatic pallet changer & & 66,000 & & & & & & \\ \hline 7 & Installation & 30,000 & 42,000 & & & & & & \\ \hline 8 & Tooling expense & 58,000 & 65,000 & & & & & & \\ \hline 9 & Annual Benefits: Year 1 & & & & & & & & \\ \hline 10 & Additional revenues & 55,000 & 36,000 & & & & & & \\ \hline 11 & Direct labor savings & - & 15,300 & & & & & & \\ \hline 12 & Setup/changeover savings & - & 4,700 & & & & & & \\ \hline 13 & Years 2-10 revenues & Constant & Growth: 13%,5 years & & & & & & \\ \hline 14 & Annual maintenance cost & 3,500 & 5,000 & & & & & & \\ \hline 15 & Salvage value in year 10 & 25,000 & 40,000 & & & & & & \\ \hline 16 & & & & & & & & & \\ \hline 17 & & & & & & & & & \\ \hline 18 & Design 1 & & & & & Design 2 & & & \\ \hline 19 & Year & Inflows & Outflows & Net CF & & Year & Inflows & Outflows & Net CF \\ \hline 20 & 0 & 0 & (209,000) & (209,000.00) & & 0 & & $(298,000) & -298000.000 \\ \hline 21 & 1 & 55,000 & (3,500) & 51,500.00 & & 1 & 56,000 & (5,000) & 51000.000 \\ \hline 22 & 2 & 55,000 & (3,500) & 51,500.00 & & 2 & 63,280 & (5,000) & 58280.000 \\ \hline 23 & 3 & 55,000 & (3,500) & 51,500.00 & & 3 & 71,506 & (5,000) & 66506.400 \\ \hline 24 & 4 & 55,000 & (3,500) & 51,500.00 & & 4 & 80,802 & (5,000) & 75802.232 \\ \hline 25 & 5 & 55,000 & (3,500) & 51,500.00 & & 5 & 91,307 & (5,000) & 86306.522 \\ \hline 26 & 6 & 55,000 & (3,500) & 51,500.00 & & 6 & 91,307 & (5,000) & 86306.522 \\ \hline 27 & 7 & 55,000 & (3,500) & 51,500.00 & & 7 & 91,307 & (5,000) & 86306.522 \\ \hline 28 & 8 & 55,000 & (3,500) & 51,500.00 & & 8 & 91,307 & (5,000) & 86306.522 \\ \hline 29 & 9 & 55,000 & (3,500) & 51,500.00 & & 9 & 91,307 & (5,000) & 86306.522 \\ \hline 30 & 10 & 80,000 & (3,500) & 76,500.00 & & 10 & & (5,000) & \\ \hline 31 & & & & & & & & & \\ \hline 32 & Loan Amortization Schedule & & & & & & & & \\ \hline 33 & Year & Interest Paid & Principal Paid & Ending Balance & & Initial Investment & $119,200 & & \\ \hline 34 & 1 & ($11,181.78) & ($7,704.36) & 100313.854 & & Interest Rate & 0.093806898 & & \\ \hline 35 & 2 & ($10,459.06) & ($8,427.09) & & & & & & \\ \hline 36 & 3 & ($9,668.54) & ($9,217.60) & & & & & & \\ \hline 37 & 4 & ($8,803.87) & ($10,082.28) & & & & & & \\ \hline 38 & 5 & ($7,858.08) & ($11,028.07) & & & & & & \\ \hline 39 & 6 & ($6,823.57) & ($12,062.58) & & & & & & \\ \hline 40 & 7 & ($5,692.02) & ($13,194.13) & & & & & & \\ \hline 41 & 8 & ($4,454.32) & ($14,431.83) & & & & & & \\ \hline 42 & 9 & ($3,100.51) & ($15,785.63) & & & & & & \\ \hline 43 & 10 & ($1,619.71) & ($17,266.43) & & & & & & \\ \hline 44 & & & & & & Erom & Dinture & & \\ \hline 45 & & & & & & rom & IPIC & & \\ \hline 46 & & & & & & & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

The Engineers Cost Handbook Tools For Managing Project Costs

Authors: Richard E. Westney

1st Edition

0824797965, 978-0824797966

More Books

Students also viewed these Finance questions