Question: begin{tabular}{|c|c|c|c|} hline 1 & A & B & C hline 2 & Period & Cash Flows & hline 3 & 0 & (60,000)

$\begin{tabular}{|c|c|c|c|} \hline 1 & A & B & C \\ \hline$

$2 & Period & Cash Flows & \\ \hline 3 & 0$

\begin{tabular}{|c|c|c|c|} \hline 1 & A & B & C \\ \hline 2 & Period & Cash Flows & \\ \hline 3 & 0 & (60,000) & \\ 4 & 1 & 5,000 & \\ 5 & 2 & 15,000 & \\ 6 & 3 & 12,000 & \\ \hline 7 & 4 & 23,000 & \\ 8 & 5 & 15,000 & \\ 9 & 6 & 20,000 & \\ 10 & 7 & 23,000 & \\ 11 & 8 & 24,000 & \\ 12 & & & \\ 13 & Discount Rate & & \end{tabular} Please see this attached Excel spreadsheet with cash flows for a potential project. Calculate the discounted payback period of the project assuming a discount rate of 11%. Report your answer in years rounded to two decimal places. Your

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

need help with the formulas. please use letters and numbers in pictures for example 1500 is C12 \begin{tabular}{|c|c|c|c|} \hline 4 & A & B & C \\ \hline87 & A & B & c \\ \hline 9 & 6 & Data Section:...

please help, i do not understand Clipboard 5 Font 5 account balances-Excel Sign in A1 On December 31, 2016, Maple Moving Company had the following balances \begin{tabular}{|c|c|c|c|} \hline 4 & A & B...

HELP Q1 Last year Carson Industries issued a 10-year, 14% semiannual coupon bond at its par value of $1,000. Currently, the bond can be called in 6 years at a price of $1,070 and it sells for $1,350....

Here is the initial data : Assumptions : Sales will increase by 15% COGS will increase by 150 Basis Points General and Admin Expenses will Increase by 50 basis points R & D, Current Assets and...

Input formulas per cell input \begin{tabular}{|c|c|c|c|} \hline 4 & A & B & c \\ \hline 25 & Quarter 3 & 84,000.00 & 14,300 \\ \hline 26 & Quarter 4 & 100,000.00 & 22,500 \\ \hline...

please solve in excel and show formulas \begin{tabular}{|c|c|c|c|} \hline d. & A & B & C \\ \hline 1 & \multicolumn{3}{|c|}{ Given } \\ \hline 2 & Today's Date & feb-05 & \\ \hline...

just answer number 5 4. You would like to open an investment company named Rip'em. The cost of building up the company is $750,000. You offer your clients the following deal: For five annual deposits...

Using the above template compute the NPV of the project and record the answer to the nearest penny. Using the template compute the IRR for project. Record your answer as a percentage, Compute the...

\begin{tabular}{|c|c|c|c|} \hline 4 & A & B & c \\ \hline 1 & Year & Quarter & Price \\ \hline 2 & 2010 & 1 & 263600 \\ \hline 3 & 2010 & 2 & 264100 \\ \hline 4 & 2010 & 3 & 259500 \\ \hline 5 & 2010...

A sales manager collected data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. In the Microsoft Excel Online file below you will find...

Hint: Consider the function h(x) = f(x)(x-a)(x - b). 33. Suppose f.g: [a, b] R is differentiable on its domain, and g' # 0. Show that 3c (a, b), such that f(a) f(c) f'(c) g(c)-g(b) g'(c) (b)).

The handle of the hammer is subjected to the force of F = 20 lb. Determine the moment of this force about the pointA. S in. 18 in.

Which is not an allowable method under MACRS? Multiple Choice 1 5 0 percent decilining balance 2 0 0 percent declining balance Stralght - IIne

will emerge over the next five to seven years, so his company could be seen as the innovator that could fill customers' needs before anyone else. He was considering personal interviews, even though...

Steve has recently begun to question whether InfoServe should promote from within or hire team leads from outside the organization. What are the pros and cons of each approach? Which approach would...

What factors might be leading to the reduced number of applications at InfoServe?

Why might certain provincial jurisdictions allow TFW to stay longer than others? For employers who rely on TFW, what other drivers would employers need to adjust for when estimating labour supply and...