HELLO EVERYBODY!!
CAN YOU GUYS HELP ME HOW TO SOLVE THIS QUESTIONS?? REALLY NEED YOUR HELP GUYS COZ I'M NOT GOOD IN EXCEL ESPECIALLY ABOUT RAND AND PMT FUNCTIONS. SO I HOPE YOU CAN HELP ME TO SOLVE THIS QUESTIONS.
..............................................................................................................................................................................
Uncle John has taken a loan from the bank to start a new business. He expects a first year revenue of $50,000 and, thereafter, revenue growing at 8% per year. His non-loan expenses are initially $30,000 per year and this grows a 4% per year. His loan repayment is $25,000 per year for 5 years.
A. construct a spreadsheet model to examine Uncle John 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?
...........................................................................................................................................................................
THANKS GUYS I HOPE YOU ARE CAN HELP ME

CAN YOU GUYS HELP ME HOW TO SOLVE THIS QUESTIONS?? REALLY NEED YOUR HELP GUYS COZ I'M NOT GOOD IN EXCEL ESPECIALLY ABOUT RAND AND PMT FUNCTIONS. SO I HOPE YOU CAN HELP ME TO SOLVE THIS QUESTIONS.
..............................................................................................................................................................................
Uncle John has taken a loan from the bank to start a new business. He expects a first year revenue of $50,000 and, thereafter, revenue growing at 8% per year. His non-loan expenses are initially $30,000 per year and this grows a 4% per year. His loan repayment is $25,000 per year for 5 years.
A. construct a spreadsheet model to examine Uncle John 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?
...........................................................................................................................................................................
THANKS GUYS I HOPE YOU ARE CAN HELP ME
