Homework answers / question archive / Shelly Cashman excel 2019 module 9 sam project 1a Author: Note: Do not edit this sheet

Shelly Cashman excel 2019 module 9 sam project 1a Author: Note: Do not edit this sheet

MS Excel

Share With

---

Shelly Cashman excel 2019 module 9 sam project 1a

Author:

Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM

website.

 

Mount Moreland Hospital

PERFORM FINANCIAL CALCULATIONS

William Schaefer

New Perspectives Excel 2019

| Module 9: SAM Project 1a

Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM

website.

 

Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM

 

Mount Moreland Hospital - Neighborhood Nurse Van

Year 4

Year 5

37

49

48

60

Total

#NAME?

$0

$234,000

$234,000

#VALUE!

#VALUE!

 

Mount Moreland Hospital - Neighborhood Nurse Van

Depreciation

Van with Medical Equipment

Long-term assets (cost)

$ 234,000

Salvage value (salvage)

$ 37,440

Life of asset (life)

7

Straight-Line Depreciation

Year

1

2

3

4

5

6

7

Annual depreciation

Cumulative depreciation

$0

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

Depreciated asset value

$234,000

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

Declining Balance Depreciation

Year

1

2

3

4

5

6

7

Annual depreciation

Cumulative depreciation

$0

$0

$0

$0

$0

$0

$0

Depreciated asset value

$234,000

$234,000

$234,000

$234,000

$234,000

$234,000

$234,000

Yearly depreciation allowance for the first year:

Yearly depreciation allowance for the last year:

 

 

Month

Month Number

Revenue

Jan 2022

1

29,443

Feb 2022

2

33,967

Mar 2022

3

34,268

Apr 2022

4

37,665

May 2022

5

38,775

Jun 2022

6

36,834

Jul 2022

7

31,995

Aug 2022

8

36,935

Sep 2022

9

38,021

Oct 2022

10

38,566

Nov 2022

11

38,775

Dec 2022

12

38,756

Jan 2023

13

36,012

Feb 2023

14

37,345

Mar 2023

15

39,552

Apr 2023

16

40,207

May 2023

17

40,113

Jun 2023

18

39,765

Jul 2023

19

30,599

Aug 2023

20

40,215

Sep 2023

21

41,750

Oct 2023

22

42,154

Nov 2023

23

40,205

Dec 2023

24

40,450

Jan 2024

25

41,599

Feb 2024

26

42,702

Mar 2024

27

42,998

Apr 2024

28

40,012

May 2024

29

44,175

Jun 2024

30

44,998

Jul 2024

31

44,765

Aug 2024

32

41,248

Sep 2024

33

45,060

Oct 2024

34

45,621

Nov 2024

35

45,987

Dec 2024

36

49,958

Jan 2025

37

48,155

Feb 2025

38

48,014

Mar 2025

39

49,109

Apr 2025

40

49,121

May 2025

41

49,342

Jun 2025

42

45,695

Jul 2025

43

44,992

 

Aug 2025

44

47,622

Sep 2025

45

48,252

Oct 2025

46

49,013

Nov 2025

47

49,211

Dec 2025

48

50,001

Jan 2026

49

50,225

Feb 2026

50

50,100

Mar 2026

51

51,225

Apr 2026

52

50,026

May 2026

53

51,245

Jun 2026

54

50,875

Jul 2026

55

49,765

Aug 2026

56

51,232

Sep 2026

57

53,012

Oct 2026

58

53,187

Nov 2026

59

54,675

Dec 2026

60

53,412

 

Mount Moreland Hospital - Neighborhood Nurse Van

Investment Returns

Investor Repayment Schedule

Payments

Net Cash Flow

Startup

$ (165,000)

$ (165,000)

Year 1

25,000

(140,000)

Year 2

32,500

(107,500)

Year 3

35,500

(72,000)

Year 4

40,500

(31,500)

Year 5

41,500

10,000

Year 6

40,000

50,000

Desired rate of return

7.30%

Present value

Net present value

$ (165,000)

Internal rate of return

 

Mount Moreland Hospital - Neighborhood Nurse Van