14 Nov BUS 180 Projected Balance Sheet
I'm working on a finance project and need guidance to help me learn.
I working on W06 project for my BUS 180 class. In the instructions is says the cash amount for January should be $1489.74 and the amount for December should be $424.74. I want to know how they came up with that answer? Here is a run down of the assignment details.
- With the assumptions and P&L provided on the spreadsheet, use the following information to create a projected Balance Sheet from January through December of year two for Kalei Ukuleles. Refer to the W06 Creative Cakes Practice Projected Balance Sheet assignment for specific instructions.
- Important Information:
- Accounts Receivable: Project that the business will have 5 days of receivables.
- Inventory: Beginning in year two, John's vendor in China will require that he purchase inventory in advance. For this reason, we will account for the Ukulele Inventory on the Balance Sheet using the following assumption: Indicate that John plans on purchasing 33 days inventory a month in advance. This means that the January inventory will be calculated using February COGS and the formula will look like this: =DaysInv/30*D27.
- In April, Days Inventory will be changed to 35 days. (Remember, we did this in the Creative Cakes practice exercise.)
- Equipment: John will purchase $500 of equipment with cash.
- Less: Accumulated Depreciation: Use the same formula as in the Creative Cakes practice exercise.
- Days Payable: Project that the business will have 15 Days Payable.
- Notes Payable: John won’t have any loans until he borrows $3000 cash in March.
- Paid-in-Capital: The January Balance is $5000 and will not change.
- Owner’s Draw: John will not be withdrawing any money from the business.
- Retained Earnings: You know this formula!
- Difference: Enter the Difference amount in the Cash cell for each month. Check to see that the Difference is zero and Total Assets = Liabilities and Owner’s Equity.
- Check your work: The Cash amount for January should be $1489.74 and the amount for December should be $424.74.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.