Answered step by step
Verified Expert Solution
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
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}
will upvote answer, please solve in excel with given formulas
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started