Create a spreadsheet model to estimate costs

Assignment Help Financial Accounting
Reference no: EM132984877

You are going to sell Frisboids (a kind of flying disc that can be used inside an apartment without damaging things) into Lithuania. Based on market research, you estimate that the market for Frisboids in that region will be 50,000 units for 2021, 60,000 units for 2022, and 70,000 units for 2023.

You project that your wholesale selling price will be €8 per Frisboid for 2021-2023. The variable cost for making each Frisboid in 2021 will be €3.70, and this cost will grow by 5% per year. The startup cost for entering the market (including opening an office, hiring sales staff, paying licensing fees, etc.) is estimated at €100,000 payable in 2021.

Problem 1: Based on these estimates and projections, create a spreadsheet model to estimate costs, revenues, and profits for 2021, 2022, and 2023.

Reference no: EM132984877

Questions Cloud

Give the journal entry on july to record the receipt : On July 12, $ 50 of goods are returned for credit. Give the journal entry on July 19 to record the receipt of the balance due within the discount period
Compute towson company net cash flows : Determine Towson Company's Net Cash Flows from Operating Activities. If the amount is an outflow then enclose the amount with dollar sign inside of brackets.
Prepare the consolidation worksheet entries on June : This plant was carried at $3,000 (original cost $20,000) in the records of Brand Ltd at time of sale. Prepare the consolidation worksheet entries on 30 June
What are the tax consequences of the sale : Beta sold its delivery truck, its only Class 10 asset, for $4,000. The original cost of the truck was $18,000. What are the tax consequences of the sale
Create a spreadsheet model to estimate costs : Based on these estimates and projections, create a spreadsheet model to estimate costs, revenues, and profits for 2021, 2022, and 2023.
Calculate the amount of raw materials and finished goods : Calculate the amount of Raw Materials and Finished Goods Inventory to be reported on Palm Imagination's June 30 balance sheet
What was dollar return and percent return : It paid a $0.35 per share dividend last year. It ended last year at $106.69. If you owned 200 shares of FedEx, what was your dollar return and percent return?
How do calculate the coefficient of variation : Idol Staff are 15% and 35%; and of Poker-R-Us are 9 percent and 20 percent. Before solving this problem, calculate the coefficient of variation.
What is portfolio return for oracle : If you have a portfolio made up of 30 percent Oracle, 25% Valero Energy, and 45 percent McDonald's, what is your portfolio return?

Reviews

Write a Review

Financial Accounting Questions & Answers

  Prepare the cost-to-equity conversion entry

Prepare the cost-to-equity conversion entry, as required by APB Opinion No. 18, on January 1, 20X8, when Hanson's investment in Novic Company ?rst exceeds 20%.

  Write the cost formula for tanning services

Using the high-low method, compute the variable rate for tanning. Compute the fixed cost per month. Using your answers to Requirement 2, write the cost formula for tanning services.

  Consumer goods manufacturing firm

The following data relate to GenMet, a U.S. based consumer goods manufacturing firm

  What is the net investment cash outflow for the project

What is the project-disposal cash flow (not including the annual operating cash flow)? What is the operating cash flow for the 3rd year of the project's life?

  Prepare the journal entries to record transactions for year

Feb.20 61,600 common shares were sold by subscription to 7 individuals, Prepare the journal entries to record the transactions for the year.

  Find what will be the winning auction offer price

Assuming Roundtree would like to sell 2.18 million shares in its IPO, what will be the winning auction offer price?14.20 1,240,000.

  What is portfolio return for mcdonald

If you have a portfolio made up of 30 percent Oracle, 25 percent Valero Energy, and 45 percent McDonald's, what is your portfolio return?

  Illustrate what are the tax advantages of operating

A foreign corporation can structure its U.S. operations as either a branch or a subsidiary. Illustrate what are the tax advantages of operating in the United States through a separately incorporated subsidiary?

  Amount and character of winchesters gains and losses

Winchester LLC sold the following business assets during the current year: automobile, $30,000 cost basis, $12,000 depreciation, proceeds $20,000; What is the amount and character of Winchester's gains and losses before the 1231 netting process?

  Who is responsible for the fair presentation

Who is responsible for the fair presentation, in all material respects, of the amounts and disclosures included in the financial statements in conformity

  What financing section of statement of cash flows report

The company also purchased treasury stock that had a cost of $10000. The financing section of the statement of cash flows will report net cash inflows of

  Calculate the present value today of annuity

The first payment will be made at the end of year 7. Assuming a required rate of return of 7%, calculate the present value today of her annuity.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd