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

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

★★★★★

3.39 Rating (158 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Determine why funding is needed for the company To start a business a company need an initial investment or initial funds to operate and to support its expenses Once a company can sustain its own expe... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

A & E Holdings profit and loss statement showed a net income of 9 3/4% of revenue or $29 250. Fifteen percent of net income was paid in corporation tax and 75% of the net income after tax was paid...

The June profit and loss statement for the Browning Company is shown. If competitive conditions make price increases impossible and management has cut costs as much as possible, should the Browning...

Create a simple Profit and Loss Statement for the first two years of your dream company following the income statement format. This is to be created from scratch for the first two years of your own...

The following is a true case. General Electric (GE), like many other large corporations, is scrutinized by financial analysts who develop quarterly forecast EPS figures for the company. The companies...

The adjusted trial balance columns of the worksheet for Rachel Company, owned by Toni Rachel, are as follows. Instructions (a) Complete the worksheet by extending the balances to the financial...

Commercial mesityl oxide, (CH3) 2CCHCCH3, is often contaminated with about 10% of an isomer having the same carbon skeleton. What is a likely structure for this compound?

A certain natural gas has the following volumetric analysis: 65 percent CH4, 8 percent H2, 18 percent N2, 3 percent O2, and 6 percent CO2. This gas is now burned completely with the stoichiometric...

Nuclear Fusion in the Sun The source of the sun's energy is a sequence of nuclear reactions that occur in its core. The first of these reactions involves the collision of two protons, which fuse...

Reflection by thin layers in Figure light is incident perpendicularly on a thin layer of material 2 that lies between (thicker) materials 1 and 3. (The rays are tilted only for clarity.) The waves of...

The profit and loss sharing agreement of the partnership of Ali, Bart, and Carrie provides a salary allowance for Ali and Carrie of $10,000 each. Partners receive a 10 percent interest allowance on...

We can solve linear systems by methods other than Gauss's. One often taught in high school is to solve one of the equations for a variable, then substitute the resulting expression into other...

A company has found that its expenditure rate per day (in hundreds of dollars) on a certain type of job is given by the function below, where x is the number of days since the start of the job....

For Problems 1 2 - 1 5 , write the system of equations with the given coefficient matrix and right - hand side vector. 1 2 . A = [ 1 - 1 2 3 1 1 - 2 6 3 1 4 2 ] , b = [ 1 - 1 2 ] . 1 3 . A = [ 2 1 3...

Edelman Engineering is considering including two pieces of equipment, a truck and an overhead pulley system, in this year's capital budget. The projects are independent. The cash outlay for the truck...

The press shown is used to emboss a small seal at E. Knowing that P = 250 N, determine (a) The vertical component of the force exerted on the seal, (b) The reaction at A. 400 mm 15 200 mm 20 G0

Knowing that the pulley has a radius of 1.5 ft, determine the components of the reactions at A and E. 3ft 9ft -9ft 3ft 6 ft 210 Ib

Belle Cosmetics Company is planning a one-month campaign for June to promote sales of one of its two cosmetics products. A total of $120,000 has been budgeted for advertising, contests, redeemable...

The condensed product-line income statement for Suffolk China Ware Company for the month of December is as follows: Fixed costs are 15% of the cost of goods sold and 40% of the selling and...

Which energytransfer diagram or diagrams represents a possible real heat engine

llustrate different ways of connecting these components together to span a range of performance requirements. [10 marks] For each of the performance categories that you identify state today's typical...

GRADED ACTIVITY #10 ( M10.1): METHODS Instruction: Create a java program using user-defines methods that will perform the 3 major functionalities of an Automated Teller Machine Withdraw, Deposit,...

Computer Programming in Java home > 11.12 Credit Card Check Digit 11.12 Credit Card Check Digit* Banks issue credit cards with 16 digit numbers. If you've never thought about it before you may not...

1. The following interface and classes have to do with the storage of information that may appear on a mailing label. Design and implement each of the described classes below. The items in bold are...

Exercise 1 Description For this lab you will write a Java program that prompts the user to enter a string. Your program should use a loop to count the characters of the string that are digits - any...

JBHs income statement and balance sheet forecasts for the period 20202022 Based on these financial statement forecasts for the period 20202022, estimate the total equity value of JBH using the...