Qn 4.01 Aunty May. Aunty May has taken a loan from the bank to start...
70.2K
Verified Solution
Link Copied!
Question
Finance
Qn 4.01 Aunty May. Aunty May has taken a loan from the bank to start a new business. She expects a first year revenue of $50,000 and, thereafter, revenue growing at 8% per year. Her non-loan expenses are initially $30,000 per year and this grows at 4% per year. Her loan repayment is $25,000 per year for 5 years. a. Construct a spreadsheet model to examine Aunty May's business financials. b. Is the business viable within the first 8 years? When does it break even? c. Do you think the loan amount is sufficient for overcoming cashflow concerns? How do you know? ? d. What if the first-year revenue is $45,000, growing at 7%; first-year expense is $25,000, growing at 3%; and loan repayment is $20,000 per year for 5 years
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
