MINICASE Garnett Jackson, the founder and CEO of Tech Tune-Ups, stared out the window as he finished his customary peanut butter and jelly sandwich, contemplating the dilemma currently facing his firm. Tech Tune-Ups is a start-up firm, offering a wide range of computer services to its clients, including online technical assistance, remote maintenance and backup of client computers through the Internet, and virus prevention and recovery. The firm has been highly successful in the 2 years since it was founded; its reputation for fair pricing and good service is spreading, and Mr. Jackson believes the firm is in a good position to expand its customer base rapidly. But he is not sure that the firm has the financing in place to support that rapid growth. Tech Tune-Ups' main capital investments are its own powerful computers, and its major operating expense is salary for its consultants. To a reasonably good approximation, both of these factors grow in proportion to the number of clients the firm serves. Currently, the firm is a privately held corporation. Mr. Jackson and his partners, two classmates from his undergraduate days, have contributed $250,000 in equity capital, largely raised from their parents and other family members. The firm has a line of credit with a bank that allows it to borrow up to $400,000 at an interest rate of 8%. So far, the firm has used $200,000 of its credit line. If and when the firm reaches its borrowing limit, it will need to raise equity capital and will probably seek funding from a venture capital firm. The firm is growing rapidly, requiring continual investment in additional computers, and Mr. Jackson is concerned that it is approaching its borrowing limit faster than anticipated. Mr. Jackson thumbs through past financial statements and estimates that each of the firm's computers, costing $10,000, can support revenues of $80,000 per year but that the salary and benefits paid to each consultant using one of the computers is $70,000. Sales revenue in 2018 was $1.2 million, and sales are expected to grow at a 20% annual rate in the next few years. The firm pays taxes at a rate of 21%. Its customers pay their bills with an average delay of 3 months, so accounts receivable at any time are usually around 25% of that year's sales. Mr. Jackson and his co-owners receive minimal formal salary from the firm, instead taking 70% of profits as a "dividend," which accounts for a substantial portion of their personal incomes. The remainder of the profits are reinvested in the firm. If reinvested profits are not sufficient to support new purchases of computers, the firm borrows the required additional funds using its line of credit with the bank. Mr. Jackson doesn't think Tech Tune-Ups can raise venture funding until after 2020. He decides to develop a financial plan to determine whether the firm can sustain its growth plans using its line of credit and reinvested earnings until then. If not, he and his partners will have to consider scaling back their hoped-for rate of growth, negotiate with their bankers to increase the line of credit, or consider taking a smaller share of profits out of the firm until further financing can be arranged. Mr. Jackson wiped the last piece of jelly from the keyboard and settled down to work. Can you help Mr. Jackson develop a financial plan? Do you think his growth plan is feasible?

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

I need help creating an Excel spreadsheet.

MINICASE
Garnett Jackson, the founder and CEO of Tech Tune-Ups, stared out the window as he finished his customary peanut butter and jelly
sandwich, contemplating the dilemma currently facing his firm. Tech Tune-Ups is a start-up firm, offering a wide range of computer services
to its clients, including online technical assistance, remote maintenance and backup of client computers through the Internet, and virus
prevention and recovery. The firm has been highly successful in the 2 years since it was founded; its reputation for fair pricing and good
service is spreading, and Mr. Jackson believes the firm is in a good position to expand its customer base rapidly. But he is not sure that the
firm has the financing in place to support that rapid growth.
Tech Tune-Ups' main capital investments are its own powerful computers, and its major operating expense is salary for its consultants. To a
reasonably good approximation, both of these factors grow in proportion to the number of clients the firm serves.
Currently, the firm is a privately held corporation. Mr. Jackson and his partners, two classmates from his undergraduate days, have
contributed $250,000 in equity capital, largely raised from their parents and other family members. The firm has a line of credit with a bank
that allows it to borrow up to $400,000 at an interest rate of 8%. So far, the firm has used $200,000 of its credit line. If and when the firm
reaches its borrowing limit, it will need to raise equity capital and will probably seek funding from a venture capital firm. The firm is growing
rapidly, requiring continual investment in additional computers, and Mr. Jackson is concerned that it is approaching its borrowing limit
faster than anticipated.
Mr. Jackson thumbs through past financial statements and estimates that each of the firm's computers, costing $10,000, can support
revenues of $80,000 per year but that the salary and benefits paid to each consultant using one of the computers is $70,000. Sales revenue in
2018 was $1.2 million, and sales are expected to grow at a 20% annual rate in the next few years. The firm pays taxes at a rate of 21%. Its
customers pay their bills with an average delay of 3 months, so accounts receivable at any time are usually around 25% of that year's sales.
Mr. Jackson and his co-owners receive minimal formal salary from the firm, instead taking 70% of profits as a "dividend," which accounts for
a substantial portion of their personal incomes. The remainder of the profits are reinvested in the firm. If reinvested profits are not sufficient
to support new purchases of computers, the firm borrows the required additional funds using its line of credit with the bank.
Mr. Jackson doesn't think Tech Tune-Ups can raise venture funding until after 2020. He decides to develop a financial plan to determine
whether the firm can sustain its growth plans using its line of credit and reinvested earnings until then. If not, he and his partners will have
to consider scaling back their hoped-for rate of growth, negotiate with their bankers to increase the line of credit, or consider taking a smaller
share of profits out of the firm until further financing can be arranged.
Mr. Jackson wiped the last piece of jelly from the keyboard and settled down to work.
Can you help Mr. Jackson develop a financial plan? Do you think his growth plan is feasible?
Transcribed Image Text:MINICASE Garnett Jackson, the founder and CEO of Tech Tune-Ups, stared out the window as he finished his customary peanut butter and jelly sandwich, contemplating the dilemma currently facing his firm. Tech Tune-Ups is a start-up firm, offering a wide range of computer services to its clients, including online technical assistance, remote maintenance and backup of client computers through the Internet, and virus prevention and recovery. The firm has been highly successful in the 2 years since it was founded; its reputation for fair pricing and good service is spreading, and Mr. Jackson believes the firm is in a good position to expand its customer base rapidly. But he is not sure that the firm has the financing in place to support that rapid growth. Tech Tune-Ups' main capital investments are its own powerful computers, and its major operating expense is salary for its consultants. To a reasonably good approximation, both of these factors grow in proportion to the number of clients the firm serves. Currently, the firm is a privately held corporation. Mr. Jackson and his partners, two classmates from his undergraduate days, have contributed $250,000 in equity capital, largely raised from their parents and other family members. The firm has a line of credit with a bank that allows it to borrow up to $400,000 at an interest rate of 8%. So far, the firm has used $200,000 of its credit line. If and when the firm reaches its borrowing limit, it will need to raise equity capital and will probably seek funding from a venture capital firm. The firm is growing rapidly, requiring continual investment in additional computers, and Mr. Jackson is concerned that it is approaching its borrowing limit faster than anticipated. Mr. Jackson thumbs through past financial statements and estimates that each of the firm's computers, costing $10,000, can support revenues of $80,000 per year but that the salary and benefits paid to each consultant using one of the computers is $70,000. Sales revenue in 2018 was $1.2 million, and sales are expected to grow at a 20% annual rate in the next few years. The firm pays taxes at a rate of 21%. Its customers pay their bills with an average delay of 3 months, so accounts receivable at any time are usually around 25% of that year's sales. Mr. Jackson and his co-owners receive minimal formal salary from the firm, instead taking 70% of profits as a "dividend," which accounts for a substantial portion of their personal incomes. The remainder of the profits are reinvested in the firm. If reinvested profits are not sufficient to support new purchases of computers, the firm borrows the required additional funds using its line of credit with the bank. Mr. Jackson doesn't think Tech Tune-Ups can raise venture funding until after 2020. He decides to develop a financial plan to determine whether the firm can sustain its growth plans using its line of credit and reinvested earnings until then. If not, he and his partners will have to consider scaling back their hoped-for rate of growth, negotiate with their bankers to increase the line of credit, or consider taking a smaller share of profits out of the firm until further financing can be arranged. Mr. Jackson wiped the last piece of jelly from the keyboard and settled down to work. Can you help Mr. Jackson develop a financial plan? Do you think his growth plan is feasible?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 6 images

Blurred answer
Knowledge Booster
Database management system (DBMS)
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education