\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & Year 1 & Year 2 & Year 3 & Points & & Year 1 & Year 2 & Year 3 & Points \\ \hline Revenue & $125,000 & & & 1 & Revenue & $125,000 & & & 1 \\ \hline CGS & & & 122,500 & 1 & CGS & & $87,500 & & 1 \\ \hline Frofit & & $87,500 & & 1 & G Profit & & & $122,500 & 1 \\ \hline Fined Costs & 40,000 & 40,000 & 40,000 & & Fined Costs & 40,000 & 40,000 & $40,000 & \\ \hline Depreciation & & & & 1 & Depreciation & & & & 1 \\ \hline Total Op. Expenses & & & 45,000 & 1 & Total Op. Expenses & 5,000 & & & 1 \\ \hline & & & & & & & & & \\ \hline Dperating Income & 17,500 & & 77,500 & 1 & Operating Income & & & 78,900 & 1 \\ \hline Tanes & & $8,925 & & 1 & Taxes & 2,625 & 8,715 & & 1 \\ \hline Net Income & $13,825 & & & 1 & Net Income & $9,875 & & & 1 \\ \hline & & & Points & 8 & & & & Points & 8 \\ \hline & & & & & & & & & \\ \hline & & & & & & & & Total & 16 \\ \hline & & \begin{tabular}{l} What \\ methad \end{tabular} & bispojectedrate sta & Qhawder & thestragh the & & & & \\ \hline e.) Calculate the & pected Book Value & * at the & end of Year 3 ( 2pt & using: & & & & & \\ \hline & & & & Points & & & & & \\ \hline & Straight Line Deprec & & & 1 & & & & & \\ \hline & Accelerated Depreci & & & 1 & & & & & \\ \hline & & & & & & & & & \\ \hline d.) As a result of & calculations, wl & ield & e highest book & alue - ch & k one (l pt): & & & & \\ \hline & & & & Points & & & & & \\ \hline & Straight Line Deprec & & & 1 & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ a.) Fill in the blanks ( 3 points) } \\ \hline & Straight Line & Accelerated (DDB) & Points \\ \hline Depreciation Year 1 & & & 1 \\ \hline Depreciation Year 2 & & & 1 \\ \hline \multirow[t]{2}{*}{ Depreciation Year 3} & & & 1 \\ \hline & & Points & 3 \\ \hline \multicolumn{4}{|c|}{ b.) Fill in the blanks (16 points) } \\ \hline \multicolumn{4}{|c|}{\begin{tabular}{l} Now that you have the depreciation expenses, you need to determine how they \\ will impact the balance sheet and income statement. Use the following \end{tabular}} \\ \hline \end{tabular} 1. Initial revenue is expected to be $125,000 with a 40% revenue growth expected year over year through Year 3 . 2. All Fixed Costs (except for depreciation) are expected to remain constant at $40,000 per year for the next three years. 3. The tax rate is 21%, but RUN DMC does not intend to utilize its NOL for the first three years. (22 Points) SHOW YOUR WORK Reliable United Nebraska Document Management Company (RUN DMC), provides electronic document management services (scanning, sorting, filing, etc.) to legal and accounting firms in the Great Plains states. The company was formed on January 1, Year 1, and adopted a December 31 Fiscal Year. Upon formation, three partners contributed $10,000 each and immediately purchased a $25,000 electronic document imaging system with a five year useful life and no salvage value. The partners do not expect to purchase any additional capital equipment during the next three years. Also upon formation, the three partners/founders of the company each received 100 shares of stock with a $1 Par Value. No further investments are expected to be made in RUN DMC during the first three years. There is no need to borrow money. The Cost of Goods Sold is solely for direct labor: The partners are the only employees. The partners agree to take 50% of the revenue and split it, as it is received, as payment for the work to be performed (Essentially the Cost of Goods Sold for RUN DMC). Partners are responsible for their own taxes and benefits. All payments are made upon signing of a contract. Fixed costs represent utilities, supplies and other operational costs which are paid for as used and billed. As an analytical consultant for RUN DMC, the partners have hired you to create Revenue and Income estimates (E) and determine whether to use the Straight Line or Accelerated (Double Declining Balance - DDB) Depreciation method. You will use the same method for tax filings and income reporting to your co-investors. Your objective is to determine which method will give generate the highest book value (Shareholder's Equity) at the end of three years. As a first step, you need to determine how the depreciation expense will impact both the balance sheet and income statement for the next three years. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & Year 1 & Year 2 & Year 3 & Points & & Year 1 & Year 2 & Year 3 & Points \\ \hline Revenue & $125,000 & & & 1 & Revenue & $125,000 & & & 1 \\ \hline CGS & & & 122,500 & 1 & CGS & & $87,500 & & 1 \\ \hline Frofit & & $87,500 & & 1 & G Profit & & & $122,500 & 1 \\ \hline Fined Costs & 40,000 & 40,000 & 40,000 & & Fined Costs & 40,000 & 40,000 & $40,000 & \\ \hline Depreciation & & & & 1 & Depreciation & & & & 1 \\ \hline Total Op. Expenses & & & 45,000 & 1 & Total Op. Expenses & 5,000 & & & 1 \\ \hline & & & & & & & & & \\ \hline Dperating Income & 17,500 & & 77,500 & 1 & Operating Income & & & 78,900 & 1 \\ \hline Tanes & & $8,925 & & 1 & Taxes & 2,625 & 8,715 & & 1 \\ \hline Net Income & $13,825 & & & 1 & Net Income & $9,875 & & & 1 \\ \hline & & & Points & 8 & & & & Points & 8 \\ \hline & & & & & & & & & \\ \hline & & & & & & & & Total & 16 \\ \hline & & \begin{tabular}{l} What \\ methad \end{tabular} & bispojectedrate sta & Qhawder & thestragh the & & & & \\ \hline e.) Calculate the & pected Book Value & * at the & end of Year 3 ( 2pt & using: & & & & & \\ \hline & & & & Points & & & & & \\ \hline & Straight Line Deprec & & & 1 & & & & & \\ \hline & Accelerated Depreci & & & 1 & & & & & \\ \hline & & & & & & & & & \\ \hline d.) As a result of & calculations, wl & ield & e highest book & alue - ch & k one (l pt): & & & & \\ \hline & & & & Points & & & & & \\ \hline & Straight Line Deprec & & & 1 & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ a.) Fill in the blanks ( 3 points) } \\ \hline & Straight Line & Accelerated (DDB) & Points \\ \hline Depreciation Year 1 & & & 1 \\ \hline Depreciation Year 2 & & & 1 \\ \hline \multirow[t]{2}{*}{ Depreciation Year 3} & & & 1 \\ \hline & & Points & 3 \\ \hline \multicolumn{4}{|c|}{ b.) Fill in the blanks (16 points) } \\ \hline \multicolumn{4}{|c|}{\begin{tabular}{l} Now that you have the depreciation expenses, you need to determine how they \\ will impact the balance sheet and income statement. Use the following \end{tabular}} \\ \hline \end{tabular} 1. Initial revenue is expected to be $125,000 with a 40% revenue growth expected year over year through Year 3 . 2. All Fixed Costs (except for depreciation) are expected to remain constant at $40,000 per year for the next three years. 3. The tax rate is 21%, but RUN DMC does not intend to utilize its NOL for the first three years. (22 Points) SHOW YOUR WORK Reliable United Nebraska Document Management Company (RUN DMC), provides electronic document management services (scanning, sorting, filing, etc.) to legal and accounting firms in the Great Plains states. The company was formed on January 1, Year 1, and adopted a December 31 Fiscal Year. Upon formation, three partners contributed $10,000 each and immediately purchased a $25,000 electronic document imaging system with a five year useful life and no salvage value. The partners do not expect to purchase any additional capital equipment during the next three years. Also upon formation, the three partners/founders of the company each received 100 shares of stock with a $1 Par Value. No further investments are expected to be made in RUN DMC during the first three years. There is no need to borrow money. The Cost of Goods Sold is solely for direct labor: The partners are the only employees. The partners agree to take 50% of the revenue and split it, as it is received, as payment for the work to be performed (Essentially the Cost of Goods Sold for RUN DMC). Partners are responsible for their own taxes and benefits. All payments are made upon signing of a contract. Fixed costs represent utilities, supplies and other operational costs which are paid for as used and billed. As an analytical consultant for RUN DMC, the partners have hired you to create Revenue and Income estimates (E) and determine whether to use the Straight Line or Accelerated (Double Declining Balance - DDB) Depreciation method. You will use the same method for tax filings and income reporting to your co-investors. Your objective is to determine which method will give generate the highest book value (Shareholder's Equity) at the end of three years. As a first step, you need to determine how the depreciation expense will impact both the balance sheet and income statement for the next three years