close

FIN320 Surpass Assignment

 FIN320 Surpass Assignment Essay

FINВ 320В

EXCELВ SHEETВ ProblemsВ

PleaseВ solveВ theВ problemsВ belowВ usingВ anВ excelВ sheetВ andВ theВ excelВ functions. В 1)В (15В pts) В A В firm В isВ consideringВ aВ projectВ withВ anВ initialВ investmentВ ofВ $170, 000В andВ requiredВ returnВ ofВ 12%. В TheВ followingВ cashВ flowsВ areВ expectedВ overВ theВ 8В­yearВ lifeВ spanВ ofВ theВ project: В Year

Funds flows

you

35, 300

2

46, 200

a few

50, 500

4

22, 620

five

15, 100

6

five, 200

several

11, 740

8

89, 300

a)В

CalculateВ theВ NetВ PresentВ ValueВ (NPV)В ofВ theВ project. В ShouldВ theВ firmВ acceptВ orВ rejectВ theВ projectВ basedВ onВ theВ NPVВ criteria? В

b)В

Calculate В theВ InternalВ RateВ ofВ ReturnВ (IRR)В ofВ theВ task. В ShouldВ theВ firmВ acceptВ orВ rejectВ theВ projectВ basedВ onВ theВ IRRВ criteria? В

c)В

Calculate В theВ ProfitabilityВ IndexВ (PI)В ofВ theВ project. В ShouldВ theВ firmВ acceptВ orВ rejectВ theВ projectВ basedВ onВ theВ PIВ criteria? В

2)(10В pts) В YouВ areВ consideringВ theВ followingВ twoВ mutuallyВ exclusiveВ projects. В BothВ projectsВ willВ beВ depreciatedВ usingВ straightВ­lineВ depreciationВ toВ aВ zeroВ bookВ valueВ overВ theВ lifeВ ofВ theВ project. В NeitherВ projectВ hasВ anyВ salvageВ value. В RequiredВ rateВ ofВ returnВ onВ ProjectВ AВ isВ 10%В andВ onВ projectВ BВ isВ 13%. В

Task A

Project B

Season

CFs

12 months

CFs

zero

-75, 500

0

-70, 000

1

19, 1000

1

12, 000

2

48, 500

2

sixteen, 000

three or more

12, 500

3

seventy two, 000

a)В

CalculateВ theВ NetВ PresentВ ValueВ (NPV)В ofВ bothВ projects. В WhichВ projectВ shouldВ theВ firmВ chooseВ basedВ onВ theВ NPVВ criteria? В

b)В

Calculate В theВ InternalВ RateВ ofВ ReturnВ (IRR)В ofВ bothВ projects. В Which В project В shouldВ theВ firmВ chooseВ basedВ onВ theВ IRRВ criteria? В

3)(5В pts)В TheВ bondsВ issuedВ byВ StainlessВ TubsВ bearВ anВ 8В percentВ coupon, В payableВ semiannually. В TheВ bondsВ matureВ inВ 11В yearsВ andВ haveВ aВ $1, 000В faceВ worth. В Presently, В theВ bondsВ sellВ forВ $952. В WhatВ isВ theВ yieldВ toВ maturity? В В В

4)(5pts)В RedesignedВ...

 Business Plan Template Essay

Business Plan Template Essay

IDENTITY: MOHAMMED LABEEB BADRI SCHOLAR ID: L0669DODO1011 MODULE: MASTER OF BUSINESS ADMINISTATION SEMESTER you – MANAGING SKILLS AND ENTREPRENEURSHIP FEBRUARY…...

Read
 Essay about Week 2 Cosmic Creation Myths Across Cultures Indicate Young

Essay about Week 2 Cosmic Creation Myths Across Cultures Indicate Young

п»ї Cosmic Creation Myths Across Ethnicities Mark Fresh HUM a hundred and five May 18, 2015 Gianoula Pavlakos Cosmic Creation Myths Around Cultures…...

Read