Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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!
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

ISE Introductory Financial Accounting For Business

Authors: Thomas P. Edmonds, Christopher Edmonds

2nd Edition

1260575306, 9781260575309

More Books

Students also viewed these Accounting questions

Question

How are time study and methods engineering related?

Answered: 1 week ago

Question

How are most students funded?

Answered: 1 week ago

Question

Explain the relationship between language and culture

Answered: 1 week ago

Question

Compare and contrast elaborated and restricted codes

Answered: 1 week ago