Question: 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

Excel problem: need an excel expert, the question is the first picture and the information to follow is below!
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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!