Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

will upvote answer, please solve in excel with given formulas Questions a) Compute the NPW and IRR for both options at MARR =12%. b) Based

image text in transcribed
image text in transcribed
will upvote answer, please solve in excel with given formulas
Questions a) Compute the NPW and IRR for both options at MARR =12%. b) Based on the metrics computed in question a, which option would be selected? c) BC is considering financing 40% of the project's initial investment at an interest rate of 9% compounded monthly. If BC pays annual installments and the required repayment period is 10 years, determine the loan amortization schedule. Note: use the project selected in question a. \begin{tabular}{|c|c|c|c|c|} \hline \multirow{3}{*}{MARRLife} & \multicolumn{4}{|c|}{12%} \\ \hline & \multicolumn{4}{|c|}{10 years } \\ \hline & \multicolumn{2}{|c|}{ M1 } & \multicolumn{2}{|c|}{ M2 } \\ \hline \multicolumn{5}{|l|}{ Investment: } \\ \hline Machine tool purchase. & & 121,000 & 5 & 125,000 \\ \hline Automatic pallet changer & & & 5 & 66,000 \\ \hline Installation. & $ & 30,000 & 5 & 42,000 \\ \hline Tooling expense & 5 & 58,000 & 5 & 65,000 \\ \hline \multicolumn{5}{|l|}{ Annual Benefits: Year 1} \\ \hline Additional revenues & $ & 55,000 & 5 & 36,000 \\ \hline Direct labor savings & - & & $ & 15,300 \\ \hline Setup/changeover savings. & - & & 5 & 4,700 \\ \hline Years 210 revenues & \multicolumn{2}{|c|}{ Constant } & \multicolumn{2}{|c|}{ Growth:13\%, 5 years } \\ \hline Annual maintenance cost & $ & 3,500 & 5 & 5,000 \\ \hline Salvage value in year 10 & s & 25,000 & 5 & 40,000 \\ \hline \end{tabular} Design 1 Design 1 \begin{tabular}{r|r|l|l|} \hline Year & Inflows & Outflows & Net CF \\ \hline 0 & & & \\ \hline 1 & & & \\ \hline 2 & & & \\ \hline 3 & & & \\ \hline 4 & & & \\ \hline 5 & & & \\ \hline 6 & & & \\ \hline 7 & & & \\ \hline 8 & & & \\ \hline 9 & & & \\ \hline 10 & & & \\ \hline \end{tabular} Loan Amertization Schedule \begin{tabular}{|c|c|c|c|} \hline Year & Interest Paid & Principal Paid & Ending Balance \\ \hline & 1 & & \\ \hline & 2 & & \\ \hline \end{tabular} Design 2 : \begin{tabular}{|r|l|l|l|} \hline Year 2. & Inflows & Outflows & Net CF \\ \hline 0 & & & \\ \hline 1 & & & \\ \hline 2 & & & \\ \hline 3 & & & \\ \hline 4 & & & \\ \hline 5 & & & \\ \hline 6 & & & \\ \hline 7 & & & \\ \hline 8 & & & \\ \hline 9 & & & \\ \hline 10 & & & \\ \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

Globalization Gating And Risk Finance

Authors: Unurjargal Nyambuu, Charles S. Tapiero

1st Edition

1119252652, 978-1119252658

More Books

Students also viewed these Finance questions