# 206 week 5

show work using excel

Answer rating (rated one time)

## Week 5 assignment solution

body preview (0 words)

file1.docx preview (1011 words)

B

**Week Five xxxxxxxxxx**

xxxxxx xxxxxxxx the following 5 exercises below in xxxxxx xxxxx or x xxxx xxxxxxxx (but xxxx xx single document). You xxxx xxxx your work where appropriate xxxxxxxx the xxxxxxxxxxxx within Excel cells xx xxxxxxxxxxxx Save the xxxxxxxxx and submit xx xx xxx appropriate xxxx xxxxx xxx Assignment Submission button.

1. **xxxxx xxxxxxx xxxxx xxxxxxxxxxxx **

xxxxxxxxx the xxxxxxx xxxxx of xxx xxxxxxxxx xxxx xxxxxx rounding to the nearest dollar:

A xxxxxx xxxx inflow of xxxxxxx xx five xxxxxx discounted xx xx xxx rate of xxxxxxx

= xxxxxx x 0.593) x $ xxxx

An xxxxxx receipt of $16,000 over xxx next xx years, xxxxxxxxxx xx xx xxx xxxx xx return.

= (16000 x xxxxxx x $ xxxxxx

x single receipt xx xxxxxxx xx the xxx xx xxxx 1 xxxxxxxx xx x xxxxxx receipt xx xxxxxxx at the end of Year xx The xxxxxxx xxx a 12% rate xx return.

= xxxxxx x xxxxxx x (10000 x 0.712) = x xxxxx

xx xxxxxx xxxxxxx of $8,000 for xxxxx xxxxx xxxxxxxx xx a xxxxxx xxxxxxx xx $10,000 xx the end xx Year xx

- - - more text follows - - -

Try it before you buy it |

## ACC 206 week 5 assignment

body preview (4 words)

xxx 206 xxxx x xxxxxxxxxx

file1.xlsx preview (1412 words)

# #1

xxxxxxxxxxxx1. Basic xxxxxxx value xxxxxxxxxxxx | ||

Calculate the xxxxxxx xxxxx xx the xxxxxxxxx cash flows, rounding xx the nearest dollar: | ||

a. x single cash xxxxxx xx xxxxxxx xx five xxxxxx xxxxxxxxxx at x xxx rate of return. | ||

b. xx annual receipt xx $16,000 xxxx xxx xxxx 12 years, xxxxxxxxxx at a 14% xxxx xx return. | ||

xx x single receipt xx xxxxxxx xx xxx xxx of xxxx x followed xx x single receipt of $10,000 xx the end of xxxx xx xxx company has a 10% xxxx xx return. | ||

d. xx xxxxxx xxxxxxx of $8,000 for three years followed xx a xxxxxx xxxxxxx of xxxxxxx xx the xxx xx Year xx xxx xxxxxxx xxx x 16% xxxx xx return. | ||

xxxxxxxxx | ||

xx x single cash xxxxxx of $12,000 xx five years, discounted at x 12% xxxx xx return. | ||

Cash xxxx | xxxxx | |

Discount xxxx | xxx | |

Period | 5 | years |

xxxxxxx Value | * xxxxxxxx | |

b. An xxxxxx receipt of $16,000 over the next 12 years, xxxxxxxxxx at a 14% rate xx xxxxxxx | ||

xxxxxx cash xxxx | x 16,000 | |

xxxxxx | 12 | years |

xxxxxxxx xxxx | 14% | |

xxxxxxx |

- - - more text follows - - -

Try it before you buy it |

## ACC 206 Week 5 Exercise Assignment__DONE 100% CORRECTLY__SECURE A+

body preview (9 words)

xxx xxx Week x Exercise xxxxxxxxxxxxxxxx xxxx xxxxxxxxxxxxxxxxx A+

file1.xls preview (582 words)

# xxxxxx 1

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx1. xxxxx present xxxxx xxxxxxxxxxxx | ||

x | Future Value | $12,000.00 |

xxxxx | 5 | xxxxx |

xxxx | xxx | |

xxxxxxx xxxxx | xxxxxx | |

b | xxxxxx xxxx Flow | xxxxxxxxxx |

xxxxxxxx | 12 | xxxxx |

xxxx | 11% | |

xxxxxxx Value | xxxxxxxx | |

c | xxxx | xxx |

Year | xxxx xxxxx | Present Value |

0 | 0.0 | 0.0 |

1 | $15,000.00 | $13,392.86 |

x | xxx | xxx |

3 | xxxxxxxxxx | xxxxxxxxx |

xxxxxxx value | xxxxxxx | |

x | Rate | 11% |

Year | Cash xxxxx | xxxxxxx Value |

x | 0.0 | 0.0 |

x | xxxxxxxxx | xxxxxxxxx |

x | $8,000.00 | xxxxxxxxx |

x | xxxxxxxxx | $5,849.53 |

4 | $10,000.00 | xxxxxxxxx |

xxxxxxx xxxxx | xxxxxxx |

# answer 2

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx4. xxxx flow xxxxxxxxxxxx xxx net present xxxxx | ||||||

xxx | Year | Period | xxxx | xxxxxxxxxxx | Cash xxxx | xxxxxxx xxxxx |

19X7 | x | xxxxx | xxx xxxxxx invested in stocks | ($10,000) | xxxxxxxxx | |

19X7 | 1 | Unspecified | xxxxxxxxx paid cash xxxxxxxxx | $1,350 | xxxxxx | |

19X8 | x | Unspecified | xxxxxxxxx paid cash xxxxxxxxx | xxxxxx | $1,003 | |

xxxx | 3 | xxxxxxxxxxx | xxxxxxxxx paid xxxx dividends | xxxxxx | xxxxxx | |

19X9 | x | xxxxxx | Mr. Greene sold xxx holdings | $13,100 | $8,393 | |

2.) | Rate | xxx | ||||

xxx | xxxxxx | |||||

3.) | xxxx xxx xxxxxx xxxxxx have xxxxxxxx xxx xxxxxxxxx stocks, xxxxxxx the xxx xxxxx xxx to xx positive, which xxxxx that this xxxxxxxxxx xxxx prove xx xx xxxxxxxxxxx | |||||

xxxxxxxxxx xxx xxxxxxx xx be xxxx at xxx end xx xxx xxxx |

# answer 3

xxxxxxxxxx3. xxxxxxxxxxxxxxx net present xxxxx xxxxxxxxxxx | ||

xxxxxxx Cost: | ||

xxxxxxxx cost | xxxxxxxxxxx | |

Site xxxxxxxxxxx | $180,000.00 | |

Duration of xxx | xx | xxxxx |

xxxxxx |

- - - more text follows - - -

Try it before you buy it |