BUS100: 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: Business Skills and Management Assignment, SUSS, Singapore

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 Aunt 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 cash flow concerns? How do you know??

d. What if the first-year revenue is $45,000, growing at 7%; the first-year expense is $25,000, growing at 3%; and the loan repayment is $20,000 per year for 5 years.