Qn 4.01 Aunty May. Aunty May has taken a loan from the bank to start...

70.2K

Verified Solution

Question

Finance

image

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!
Become a Member

Other questions asked by students