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