Question
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](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
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](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started