Question 1
Q4.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.
- Construct a spreadsheet model to examine Aunty May’s business financials.
- Is the business viable within the first 8 years? When does it break even?
- Do you think the loan amount is sufficient for overcoming cashflow concerns? How do you know?
- 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?
Stuck with a lot of homework assignments and feeling stressed ? Take professional academic assistance & Get 100% Plagiarism free papers
Answer
Looking for Plagiarism free Answers for your college/ university Assignments.
Recent Solved Questions
- BUS 304 Assignment: Strategic Analysis of Accounting Standards & Corporate Ethics
- RBP020L056 A Strategic Management Assignment Report: External & Internal Analysis with Strategic Options for Business Growth
- Capital Budgeting Assignment Report: PIONG Corporation Case Study on Risk & Investment Analysis
- BCAF003 Business Accounting Assignment : Temasek Polytechnic Case Study on Transactions, Equity & Trial Balance
- 304SE Energy Systems Assignment: Boiler Efficiency & 3-Bus Power Flow Case Study with Carbon Emission Analysis
- SM9532 International Expansion Strategy Assignment Report: CAGE, PND & AAA Analysis for Global Market Entry
- PSB6023CL Strategy and International Business Simulation Assignment Report: Automotive Case Study on Strategic Decision-Making and Performance Review
- ESG in Maritime Industry Assignment : Literature Review on Environmental, Social and Governance Practices
- CVE2332 Seepage and Flownet Analysis Assignment : Singapore River Cofferdam Case Study for Cost-Effective Sheet Pile Design
- DSWSH MC2 Electronic Security Assignment: Protection in Depth Plan for American International School (AIS) Singapore