Excel problem: need an excel expert, the question is the first picture and the information to follow is below!
Provided Chloe makes her loan payment each month, does it make'any di "erence if she makes those payments at the beginning of the month or end of the month? Answer "aa" below with "Yes". "No" or "The actual timing of the poyment within the month is irelevant". Justify your answer in "b" belew. a) b2 Chloe's Coffee Shop Loan Analysis - Option 1 Loan Analysis - Option 2 13 14 15 16 17 18 19 20 21 Loan Analysis - Option 3 22 36 37 Chloe's Coffee Shop \begin{tabular}{|l|l|r|} \hline 1 & Chloe's Coffee ShOP & \\ \hline 2 & & \\ \hline 3 & & 3.50% \\ \hline 4 & Discount Rate & $218,000.00 \\ \hline 5 & Total Initial Investment & \\ \hline \end{tabular} 6 7 \begin{tabular}{|c|r|r|} \hline 8 & \multicolumn{2}{|c|}{ Cash Flows } \\ \hline 9 & Year 0 & $218,000.00 \\ \hline 10 & Year 1 & $10,000.00 \\ \hline 11 & Year 2 & $12,300.00 \\ \hline 12 & Year 3 & $15,100.00 \\ \hline 13 & Year 4 & $18,600.00 \\ \hline 14 & Year 5 & $22,800.00 \\ 15 & Year 6 & $28,100.00 \\ \hline 16 & Year 7 & $34,600.00 \\ \hline 17 & Year 8 & $42,500.00 \\ \hline 18 & Year 9 & $52,400.00 \\ \hline 19 & Year 10 & $64,400.00 \\ \hline 20 & & \\ \hline \end{tabular} 20 22 23 Internal Rate of Return 24 Declining-Balance Depreciation \begin{tabular}{|r|r|c|c|c|} \hline 16 & Depreciation expense for year & Accumulated depreciation at end of year & Book value at end of year \\ \hline 17 & 1 & $4,272.00 & $4,272.00 & $19,728.00 \\ \hline 18 & 2 & $3,511.58 & $7,783.58 & $16,216.42 \\ \hline 19 & 3 & $2,886.52 & $10,670.11 & $13,329.89 \\ \hline 20 & 4 & $2,372.72 & $13,042.83 & $10,957.17 \\ \hline 21 & 5 & $1,950.38 & $14,993.20 & $9,006.80 \\ \hline 22 & & & & \\ \hline 23 & & & & \\ \hline \end{tabular} \begin{tabular}{|r|l|r|} \hline 1 & Number of Customers \\ \hline 2 & & \\ \hline 3 & Mean & 158.6452 \\ \hline 4 & Standard Ei & 3.703108 \\ \hline 5 & Median & 156 \\ \hline 6 & Mode & 178 \\ \hline 7 & Standard D & 20.61803 \\ \hline 8 & Sample Var & 425.1032 \\ \hline 9 & Kurtosis & 0.82436 \\ \hline 10 & Skewness & 0.2768 \\ \hline 11 & Range & 70 \\ \hline 12 & Minimum & 122 \\ \hline 13 & Maximum & 192 \\ \hline 14 & Sum & 4918 \\ \hline 15 & Count & 31 \\ \hline 16 & Largest(1) & 192 \\ \hline 17 & Smallest(1) & 122 \\ \hline 18 & Confidence 7.562755 \\ \hline \end{tabular} Chloe's Coffee Shop Chlno's Coffen Shon