Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

The items in bold with need are what I need help with for this question. Prepare a financial plan for U.S. Auto Parts Network, Inc.

The items in bold with "need" are what I need help with for this question.

Prepare a financial plan for U.S. Auto Parts Network, Inc.

Stock Symbol PRTS

Need - a profit-and-loss statement for a 3-year period with formulas in Excel. Project revenue, stating realistic assumptions, such as growth per year, in your projections.

Need - budget with formulas in Excel that includes starting balances, monthly costs, loan/investment payments for loan, cash flow projections, and required revenue.

Need the business case for $200,000 in funding. Items crossed out are done.

  • Determine why funding is needed for the company.
  • Determine the sources of funding. Considerself-funding, borrowing, equity, venture capital, etc.
  • Evaluate the requirements of each funding source you determined appropriate.
  • Analyze the associated risks of each funding source.
  • Decide which sources are the best fit for your company based on the requirements of each. Justify your decision.
  • Need - Assume use of a bank loan for the $200,000 with any APR.
  • Need - Estimate the cost of capital for both short-term and long-term funding sources. Research current estimated APRs for your selected sources of funding. Consider creating a table or chart to display this information.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

9781285586618

Students also viewed these Accounting questions