Periodic financial statements | Accounting homework help

1707214695982_1707214490988_InterviewChallenge-AdminAccountingIntern2024.xlsx

Interview challenge

Pyramidia Ventures
Interview Challenge – Accounting
Admin & Accounting Intern
Prepare the following challenge and send your report in Excel to [email protected]
You are the Accounts Assistant of Pyramidia Ventues Ltd. You are tasked with preparing the periodic Financial Statements.
In any cases where the information is incomplete (indicated with a ?), you’ll have to make and cite your assumptions explicitly.
1. Prepare 12-months of monthly financials, from July 2023 to June 2024.
2. Prepare an Income statement for the year and Opening and Closing Balance sheet for the end of June 2024.
The below information is available. Highlight any concerns or comments
Item Items as of July 2023 % Assumptions
Sales of Tomatoes Ksh800,000 Growing at 5% per month
Sales of Leafy Greens Ksh500,000 Growing at 8% per month
Rent of sales branches Ksh10,000 Constant monthly
Salaries Ksh150,000 Growing by 5,000 every month
Sales & Marketing cost Ksh80,000 Growing the same as sales volume growth
Other admin Ksh40,000 Growing at 2% monthly
Gross Margin on Tomatoes 26% As of January, GM improves to 28%
Gross Margin on Leafy Greens 24% As of January, GM improves to 26%
Long-term bank debt Ksh5,000,000 5-year term loan with annual principal repayment in January
Interest on debt ? Payable monthly. Please suggest interest rate
Purchase of new car ? Buy 1 small car in the coming year. Please suggest price and how to finance
Electricity and water Ksh15,000 2% Monthly bill, rising at 2% per month
Current assets Ksh3,400,000
Current liabilities Ksh500,000
Property, plant & equipment Ksh6,000,000
Accumulated depreciation Ksh900,000
Financial year depreciation Ksh300,000
Stockholder equity Ksh3,000,000

&”Calibri,Regular”&K000000&T_x000D_&D &”Calibri,Regular”&K000000Confidential_x000D_&F &”Calibri,Regular”&K000000Page &P _x000D_of &N

image1.jpeg

Calculate the price of your order

Select academic level, specify pages, and choose your desired paper type. Choose the deadline for your order.
To reduce the cost of our essay writing services, select the lengthier deadline.
We can't believe we just said that to you.

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Complimentary cover page and references
  • Assurance of plagiarism-free content
  • Money-back guarantee for your satisfaction
  • Unlimited revisions
  • 24/7 customer support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Referencing styles: APA, MLA, HARVARD, CHICAGO/TURABIAN, and IEEE

Our guarantees

Delivering exceptional quality at an affordable price is just the beginning.
We offer 5 advantageous guarantees to ensure a seamless, gratifying, and secure experience.

Money-back guarantee

Our commitment to quality allows us to offer a money-back guarantee, ensuring transparency and your utmost satisfaction.

Read more

Plagiarism-Free Assurance

Every paper is crafted from scratch and rigorously scrutinized through advanced plagiarism-detection software, eliminating all possibilities of plagiarism.

Read more

Unlimited Revisions

Our free revisions guarantee ensures your satisfaction. We refine your paper until you are entirely content, ensuring peace of mind.

Read more

Stringent Privacy Measures

Your emails security adheres to international data protection regulations, and trustworthy payment systems safeguard your financial details.

Read more

Equitable Collaboration

Entrusting us with your funds means acquiring a service backed by expertise. Explore our comprehensive terms and conditions for transparent business interactions.

Read more

Why Expert Academic Writers is the No.1 Essay Writing Service for Students

  1. Custom-written and plagiarism-free papers
  2. Timely delivery
  3. Customer satisfaction
  4. Confidentiality
  5. Highly trained authors
  6. Affordable prices

Let Professionals Take Care of your Academic Paper