Assume required cash on hand is two times the current year SG&A expense in each of the projected years. What is your expected total cash on balance sheet in 2013? The SG&A expense in 2013 is $11,044.

A. None of these

B. $101.2 bln

C. $20.1 bln

D. $66.4 bln

I have done everything the professor has asked for, but it still feels like I'm doing something wrong. This HAS to be A... right? I hope the years I posted accurately represent where they should be in the rows. I can't freeze the panes in this spreadsheet.

2012 Actual 2012 2013 2014 2015 2016 2017 $121,251 $20,080 $20,080 $36,987 $22,088 $86,896 $24,297 Balance Sheet Total Cash Required Cash Excess Cash (plug) Accounts receivable Inventories Other Current Assets (10.3% of COGS) Net PPEN Other (12.3% of COGS) Total assets $121,251 $18,692 $791 $9,041 $15,452 $10.837 $176,064 $18,692 $791 $9,048 $15,452 $19.250 $83,314 $20,561 $870 $9.953 $16,997 $21.176 $106,544 $22,617 $957 $10,948 $18,697 $23.293 $163,408 $141,795 $26,726 $115,068 $24,879 $1.053 $12,043 $20,567 $25.622 $225,959 $202,184 $29,399 $172,785 $27,367 $1,158 $13,247 $22,623 $28.185 $294,765 $268,612 $32,339 $236.273 $30,104 $1,274 $14,572 $24,886 831003 $370,451 Liabilities and Net Worth Accounts payable (24.1% of COGS) Accrued expenses (7.7% of COGS) Other current liabilities (12.1% of COGS) Other non-current liabilities (22% of COGS) Total liabilities Equity Total $21,175 $6,749 $10,618 $19,312 $57,854 $118,210 $176,064 $21,175 $6,749 $10,618 $19,312 $57,854 $3,041 $54,813 $23,288 $7,441 $11,692 $21,259 $63.680 $42,865 $106,544 $25,617 $8,185 $12,862 $23,385 $70,048 $93,361 $163,408 $28,178 $9,003 $14,148 $25,723 $77,052 $148,907 $225,959 $30,996 $9,903 $15,562 $28,295 $84,758 $210,007 $294,765 $34,096 $10,894 $17,119 $31,125 $93,233 $277,217 $370,451