You will need to forecast an income statement for Tortuga based on the assumptions provided (5 points). Next forecast the balance sheet for Tortuga based on the assumptions provided and iterate to balance the balance sheet and solve for external funding required (10 points). You don't need to show iterations, just provide the amount required to balance will all appropriate links. Last, you'll want to determine sources and uses and ensure it matches your forecast model (5 points). For capex, Tortuga is buying 200 in new assets and depreciating 60. Fill in all cells that are shaded yellow and put your name on the file before uploading.

(i) UPDATES AVAILABLE Updatestonotficeare ready to be installod but first we nesed to slosesemeapps: Update now A1 Numbet 5) A1 Balance Sheets Upolate now Liabilities and Owners' Equity Current liabilities: Bank loan Accounts payable Current portion long-term debt Accrued wages Total current liabilities Long-term debt Common stock Retained earnings Total liabilities and owners' equity o P R 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 balance (c) $501,02660281,1648501501,0433,207 $50 929 $50 $50 1,025 1,235 100 371,0668001501,6383,655 50251,1507501502,3314,381 \begin{tabular}{r} 100 \\ 50 \\ \hline 1,435 \\ 650 \\ 150 \\ 3,236 \\ \hline 5,470 \\ \hline \end{tabular} (c) 0 s point: Wpdste row B C. 0 fe - Balance Sheets Forecast: 2019 2020 2021 2023E Comments Assets Current assets: Cash and securities: Accounts recelvable Inventories Prepaid expenses Total current assets Net fixed assets Total assets Liabilities and Owners' Equity Current liabilities: Bank loan Accounts payable Current portion long-term dobt Acerued wages Total current liabilities Long-term debt Common stock Retained eamings Total liabilities and owners' equity \begin{tabular}{r} $50 \\ 1,026 \\ 60 \\ 28 \\ \hline 1,164 \\ 850 \\ 150 \\ 1,043 \\ \hline 3,207 \\ \hline \end{tabular} \begin{tabular}{r} $50 \\ 929 \\ 50 \\ 37 \\ \hline 1.066 \\ 800 \\ 150 \\ 1.698 \\ \hline 3.655 \\ \hline \end{tabular} \begin{tabular}{r} $50 \\ 1,025 \\ 50 \\ 25 \\ \hline 1,250 \\ 750 \\ 150 \\ \hline 2,331 \\ \hline 4,381 \\ \hline \end{tabular} \begin{tabular}{r} $50 \\ 1,235 \\ 1,00 \\ 50 \\ \hline 1,435 \\ 650 \\ 150 \\ 3,236 \\ \hline 5,470 \\ \hline \end{tabular} \begin{tabular}{|l|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} External fundine required L 1. 8 s Mi 16 days sales co DsO 6 times turnover hold constant \begin{tabular}{|lr|} \hline \multicolumn{2}{|c|}{ Copex } \\ \hline Buy & 200 \\ \hline Dep & 60 \\ \hline Net & 140 \\ \hline \end{tabular} 35 day paryables 5100 amortiration Fold constant BASE Iterate until balance P26=0 10 points Tortuga is Tortuga \&s Tertuga History Tortuga 5 -forecast Tortuga B5-Forecant Tertwos Cath fiew T